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

5 Replies

  • 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" )