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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k  Mariusz  many thanks for helping.

 

parry2k I created a new measure: If ( [ COLUMN1 ] > [AVERAGE MEASURE] ; "Red"; "Green" )

 

but he is formatting all the cells green..

 

Mariusz  your solution didn´t work out. PBI doesn´t allow me select your measure.

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

     

    Sorry, you need to set my example like below.

     

    Best Regards,
    Mariusz

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

    Please feel free to connect with me.
    Mariusz Repczynski