Skip to main content

Hello Pigment community,

 

Quick one here. I want to modify the Month Dimension in my calendar but “Cannot update a protected property (eg. built-in properties of calendar dimensions)”

I’m currently showing Jun 23 (MMM YY) and would like to switch to Jun-23 (MMM-YY).

How can I tune my own Calendar?

Thanks in advance !!

Guillermo

Hi @Guillermo Puls 

Your requirement can be achieved by creating property in Month Dimension, Please following Steps to achieve it.

Step-1

Create New Property in Month Dimension with Unique List Item and apply following formula.

LEFT(Month.Name,3) & "-" & RIGHT(Month.Name,2)

So, Your output results will be:

 

Step-2
Click on the setting in Month dimension and In Special Property, Set that Property as Default display name
 

 

After that, if you create any metric than you can see that your month will be showing like MMM-YY format.
 

Hope, I have answered your question.

Thanks
 


Feeling like a newy, Thanks a lot @abhilashsawla.

 

 


Your Welcome @Guillermo Puls 


Reply