Forum Discussion
Use Font colour formatting on Calculation item with %
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?
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.
2 Replies
v-jingzhangCommunity Support
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
Community Champion
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 🙂
