Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional formatting based on a dynamic value (slicer)

Hi guys,   so, basically every time I change my slicer, a new value is calculated (measure - it´s an avarage)   how do I make a conditional formatting based on this value that changes when I clic...
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

You can create a measure like below.

Measure 
INT( [COLUMN1] > [AVRAGE] )

And use this measure for conditonal formating in your table

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous and make sure in conditional formatting, you choose Format by Field Value and then select KPI Color in drop down list

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    EDIT:

    Mariusz  i did it, but its not formatting. nothing happens.

     

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      Hi Anonymous 

      Have you changed to "Format By" = Rules?

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski


       

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous sorry couple of things are getting mixed up based on solution Mariusz  and I are providing.

       

      If you want to compare value in measures to set the color, you should create another measure like I mentione previously but if you are comparing your measure against fixed value then you should choose the method Mariusz provided.

       

      As you can see there are many option for conditional formatting, you have to see what best fit for you. in case you are comparing two measures I would do something like this

       

      KPI Color= 
SWITCH ( TRUE()
[Measure 1] > [Measure 2], "Green",
[Measure 1] = [Measure 2], "Yellow",
"Red"
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        guys, I really appreciate your effots on helping me.

         

        I don´t know why it didn[´t work out I tried everything.

         

        For some reason PBI is considering all values smaller than average.