Forum Discussion
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...
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
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Anonymous and make sure in conditional formatting, you choose Format by Field Value and then select KPI Color in drop down list