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 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.