Forum Discussion
Solved
Conditional Formatting Matrix Table - Reflecting Percentages within Customer Territories
I have a matrix table that I'm looking to organize with conditional formatting (that way customers stand out for the right category). In this case, I want to show that customers in Fort Myers Area ha...
Hi avp115 ,
Do you want to do Conditional Format by following the value of measure (each value/grouped column total)?
Not quite sure about the logic of calculating Column total, you can create a meausure:
DIVIDE( MAX('Table'[Value]), Column total)Then by selecting [meausre] in the background color
If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi avp115 ,
try to apply conditional formatting for the background with a measure like:
measure =
SWITCH(
MAX( tablename[area]),
"Fort Myers", "Red",
"Sarasota", "Green"
)
for more info:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting