Forum Discussion

JohnMc7's avatar
JohnMc7
Regular Visitor
3 years ago

Conditional Formatting with Calculation Groups

Hi

 

Looking for some help with conditional formatting (icons) when using calculation groups and multiple measures.

 

My model:

FactKPIs: DayID, Product, VarA--VarE

DimCalendar: DayID. Fact KPIs linked by DayID

DimProduct: Product to Name. Fact KPIs linked by Product

 

DimDates: WeekendID - used in a slicer to select a week and used in time intelligence calcs, disconnected table

SlicerWeeks: Weeks (1-52) - used in a slicer to select number of weeks and used in time intelligence calcs, disconnected table 

 

I have a measures table. VarA -- VarE which are the sums of the Vars from the Fact table. Plus another measure Dummy (Dummy = BLANK())

I also have two calculation groups:

CalculationGroupTIStatic - This Year, Last Year and YoY calculations

CalculationGroupMeasures - VarA--VarE in a calculation group

 

I create a matrix:

Row: ProductName

Columns: CalculationGroupTIStatic & CalculationGroupMeasures

Values: Dummy

It's at this point i hit a brick wall on how to apply conditional formatting to the YoY values only to generate icons (e.g <0%;0%;>0%)

 

Similarly i've created a 2nd matrix

Row: ProductName

Columns: CalculationGroupTIStatic 

Values: VarA--VarE

Also at this point stuck how to apply a conditional formatting to the YoY values whilst only creating a single conditional formatting measure (as in the real world example can have significantly more than 5 vars)

 

I've read pretty much read all the literature associated with the problem and can't find a solution that fits the above.

 

Any guidance would be greatly appreciated

 

https://drive.google.com/file/d/1IyhUm2ED26pRtVhYC0LgonXnHwbDm6it/view?usp=share_link

 

No RepliesBe the first to reply