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_ I have a similar solution done a long time ago, see attached. In this, if values are different than it highlights whereas in your if the value is the same that highlights the row, you can change reverse logic in the Dax function and implement the solution in your model.

 

It is pretty straight forward, if you still run into an issue, let me know.

 

 

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
 
 

In terms of the example you showed me, if I had C2, S1, Server 2 with an amount of 200 and only selected Servers 1,2,3, the result is below:

 

It highlights the C2, S1 row because Server 4 still has a different value for it. For what I'm trying to do, I'd like it to be clear. Hopefully that makes more sense.

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

      • 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