Forum Discussion

MihaiH's avatar
MihaiH
Frequent Visitor
3 years ago

Conditional formatting for clustered column chart with Legend

I have a table that shows values for different KPIs, for a specific date: From the month and year columns I also created another column named Date. I have one clustered column chart that show...
Need Help
MihaiH's avatar
MihaiH
Frequent Visitor
3 years ago

Hi v-jianboli-msft 

Thank you for your suggestion. I tried this and it doesn't work, it shows all the labels as green, although some are positive and some are negative:

The chart looks like this:

I forgot to mention, the Δ YoY measure looks like this:

Δ YoY = SWITCH(

TRUE(),

max([Year])=2022,CALCULATE(SUM([Value]),[Year]=2022)/CALCULATE(SUM([Value]),[Year]=2021)-1,

max([Year])=2021,CALCULATE(SUM([Value]),[Year]=2021)/CALCULATE(SUM([Value]),[Year]=2020)-1)

 

Thank you,

Mihai