Metrix Row Background Color Change Using Conditional Format

[Anonymous]

How Do I change the Matrix Row Background color Using Conditional Format?

The data set :

The Report :

The Requirement is to only change the background of the Measure Category as mentioned below :

(Note : The Measure Field background was achieved using the background format option for the Values field.)

Any help is highly appreciated.

Thanks,

Abhisek

[Anonymous]

Dear @amitchandak , any help to the problem I am facing ?
Thanks for the help.

[Anonymous]

HI @Anonymous,

Yes, it is possible to do conditional formatting on the subtotal levels.
According to your snapshot, I think you may need to transform your table structure before applying conditional format. Can you please share some dummy data and paste it here in 'table' format then we can test it?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks @amitchandak . I was able to use conditional formatting and in the value part this is achived.
Below is my present state of the report.

The only point where I am struggling is to have conditional formatting for Matrix Row Values.

Thanks.

[amitchandak]

@Anonymous , One  is you can check style, In that you can get some options 

You can use conditional formatting using measure(field value option)  - but that will happen on values

If(isinscope(Table[Category]) , "Grey", "White")

Show on row it the option that will show measure on row

For the format, you might have to consider the calculation group

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

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0