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

Hi parry2k , it works for the most part. I tried it on my dataset. There are some where it's the same but it still becomes highlighted. Any ideas?

 

I'm not entirely clear on how conditional formatting applies by using the measure. Does it look at it columnwise, or rowwise or some combination? I might be able to figure it out from there. Thank you again.

 

Edit: I'm trying to upload a picture  but it won't let me. I made this table to show what kind of output I'm getting for some of the rows

 
 
|0.140661000||0.140661000|0.140661000
|0.360054000|0.360054000|0.360054000
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