conditional formatting entire row one color based on first column

[Anonymous]

Hi,

I want to make entire row in the table visualization to one color based on value of the first column. 

First column is store location,  based on the that I want the entire row in one color.

I tried matrix it did not work since there is no measure value in the table

I found the way to add new column to convert the text to value and use the conditional formatting but that works only for the column but want the rule to be applied for the entire row.

also, want the line break for each store location. not sure if these are possible in table visualization

thanks

[amitchandak]

@Anonymous , In the matrix you can not do conditional formatting for rows/columns.

You can do that for values. But you have to repeat each value

Or you can use a measure for conditional formatting

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
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3