Forum Discussion
Conditional Formatting for a text column in matrix visual
Let's say I have matrix visual as shown below.
I want to know how i should handle the below requirement
If Sales Territory is External, I want all the row background to be in RED color.
If Sales Territory is Far West, I want all the row background to be in Blue color.
If Sales Territory is Great Lakes I want all the row background to be in Yellow color.
If Sales Territory is Far West, I want all the rows to be in Blue color.
The important thing is coloring should happen to all the columns including Sales Territory column also.
Can someone advise me?
imagautham , Create a color measure like below and use that in conditional formatting using field value option
Switch( True(),
[Sales Territory] = "External", "RED",
[Sales Territory] = "Far West", "Blue",
[Sales Territory] = "Great Lakes", "Yellow",
[Sales Territory] = "Far West", "Blue"
)You can not color row/column in matrix visual, you have to color Values
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
3 Replies
imagautham , Create a color measure like below and use that in conditional formatting using field value option
Switch( True(),
[Sales Territory] = "External", "RED",
[Sales Territory] = "Far West", "Blue",
[Sales Territory] = "Great Lakes", "Yellow",
[Sales Territory] = "Far West", "Blue"
)You can not color row/column in matrix visual, you have to color Values
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539amitchandak Thanks for the reply. But does this mean, at the present, Power BI does not have any option to apply conditional filtering on the below scenario?
If Sales Territory column is external, I want the background of that sales Territory column to be RED.
Hi imagautham,
Currently, you can't use one condition formation to enable multiple formattings. I'd like to suggest you set the second conditional formatting to apply background color based on conditions.
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
