Conditional formatting of Matrix rows not a values

[community_pinki]

Hi Team,

I am able to achive conditional formatting for values in matrix and now stuck in implementing same for rows in matrix.

Any suggestion would be appriciate.

Thanks

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please try to create a rank measure and make this measure be used as a base field for the conditional formatting.

Please check the below picture and the attached pbix file.

[community_pinki]

how can we apply colors for category as you have pulled category on rows of a matrix.

If I have category slicer and I have selected category "a" from slicer then entire row of matrix visual should be highlted with then specific color. Is this possible? 

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

slicer select conditional format background: =
VAR _SelectCategory =
    VALUES ( 'category slicer table'[category] )
VAR _condition =
    COUNTROWS ( FILTER ( category, category[category] IN _SelectCategory ) ) > 0
RETURN
    IF ( ISFILTERED ( 'category slicer table'[category] ) && _condition, "yellow" )

[community_pinki]

will category be colored as yellow?

[Anonymous]

Hi @community_pinki ，hello Jihwan_Kim ,thank you for your prompt reply!
The short answer is “No” because the category column under “Rows” do not have conditional formatting settings:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.