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...
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.
Anonymous it is always good to see what the measure value you are getting at each row. so in the table you showed, drop those two measures whcih you are using in KPI color so that we can see what value you are getting and make sure you are getting expected value otherwise we are shooting the dark, doesn't know what those measures are and how you data models looks like? Read this post to get your answer quickly and it saves everyone time.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490