Conditional formatting

[willatkinson]

Hi, I am facing an issue regarding applying conditional formatting based on an increase/decrease in values from the previous quarter. The columns in the visual are from the date hierarchy. Is it possible to apply conditional formatting to have icons applied to each quarter in the visual based on the previous, even though they are not explicit columns from the table?

[amitchandak · Accepted solution]

@willatkinson , You can use get previous Qtr using offset and have diff of two

Diff = [Measure] - CALCULATE([Measure], OFFSET(-1, ALLSELECTED('Table'[Qtr],), ORDERBY('Table'[Qtr],asc)))

If needed add a year in offset

Now you can use this measure for icon conditional formatting

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/