Use Font colour formatting on Calculation item with %

[Anonymous]

I have 4 calculation items in my report: Theser are created by using Tabular editor. When I use conditional formatting for font colour, it neglects the YoY%. Is there a way to have the colour coding of -ve % figures with calculation groups?

[v-jingzhang · Accepted solution]

Hi @Anonymous 

It is possible. You can refer to below blogs and videos. You need to create a measure for conditional formatting. When selectedvalue(CalculationGroup[Calculation Item]) is "YoY%", create different rules for it. 

Conditional Formatting In Calculation Groups - Power BI - Enterprise DNA

Conditional formatting with Calculation Groups in PowerBI Matrix visual - Exceed

Conditional formatting in Power BI with calculation groups - YouTube

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[TheoC]

Hi @Anonymous 

If you go to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-by-rules-for-percentages  you should get the answer that you're after.

Importantly, you may need to create specific rules for % given that 1 is 100% and -1 is -100%, hence why it's being missed in your table at the moment.

Hope this helps. Reach out if not and will try assist more.

Theo 🙂