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_ sure I will tweak the measure, I think that will do it. stay tuned

parry2k's avatar
parry2k
Super User
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.⚡