Forum Discussion

goalie_'s avatar
goalie_
Helper III
6 years ago
Solved

Matrix visual color conditional formatting

Hi,   I'm relatively new to Power BI. I am looking to highlight unique rows in a matrix visual such as below. In this case, I'd like to have the Carbs and Protein rows highlighted but NOT the sugar...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    goalie_ change following measure

     

    # of servers = 
COUNTROWS ( 
        CALCULATETABLE( 
            VALUES ( Amount[Server] ),
            ALLSELECTED ( Amount ) 
        ) 
    )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

goalie_ what is the business logic which rows get highlighted over another?

goalie_'s avatar
goalie_
Helper III
6 years ago

The contents of the row contain different values for each column.

 

For example in carbs, there's 50, 45, 39 which are all different numbers so it should be highlighted. IF they were 50, 45, 50, then the row would need to be highlighted. However, if they all had the same value 50,50,50 then it shouldn't be highlighted. 

 

Edit: there could be other rice types too. But with slicers, focused on the three mentioned above.