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

goalie_'s avatar
goalie_
Helper III
6 years ago

I think I narrowed it down. I only see it happening when there's three options for the columns in slicer that are selected.

goalie_'s avatar
goalie_
Helper III
6 years ago

Still not sure why it's happening. But I found a solution. Incase anyone wants to know for the future, I encompassed the original DAX statement with the round( ) function upto 10 decimal points. And that seemed to do the trick.

 

Thank you again parry2k