EPM IBP Formatting. Time Profile Level formatting for Quarter and Year

[vinmittal]

The goal is to achieve similar formatting for Quarter and Year columns in the IBP Template using the IBPFormatting Sheet.

I have tried the column/row member formatting for Year with changing the priority to row and column, but it doesn't apply.

Question -
How to define different formatting for columns based on the column value?

[piyush_parekh · Accepted solution]

Hi Vinay,

Pull first year in planning horizon (for e.g.,2020) in planning view. Go to EPM formatting sheet > Dimension Member/Property Formatting > Column > Add Member/Property > Property Selection. Search and select Mixed Time. On right hand side, select below fields :

Property : ID

Operator : Greater than or equal to

Value : <Period ID of first year in planning horizon for e.g., 90053>

Click on OK. Apply your formatting on value and label cell and refresh planning sheet. This should highlight all years.

Regards,

Piyush