Forum Discussion

community_pinki's avatar
community_pinki
Helper II
2 years ago

Conditional formatting of Matrix rows not a values

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  
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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's avatar
community_pinki
Helper II
2 years ago

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's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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's avatar
      community_pinki
      Helper II
      2 years ago

      will category be colored as yellow?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.