Forum Discussion
Conditional formatting based on a dynamic value (slicer)
Hi Anonymous
You can create a measure like below.
Measure INT( [COLUMN1] > [AVRAGE] )
And use this measure for conditonal formating in your table
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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.
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" )
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
