Forum Discussion
cmilligan262
4 years agoHelper II
PowerBI forcing Value Conditional Formatting
I'm trying to add conditional formatting to my totals in PBI. I'm having an issue where it is forcing me to designate values to apply the conditional formatting rather than basing it on lowest, middl...
v-yalanwu-msft
4 years agoCommunity Support
Hi, cmilligan262 ;
If your visual object is a matrix and does column totals, you need to create a measure using the ISINSCOPE() function;
Then you can choose the appropriate method from Color based on a calculation, Color by Color values, Color by Rules, Color by Color scale.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
If that still doesn't work, can you share more about the table structure and the result presentation you want to output?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.