Forum Discussion
Solved
Conditional Formatting based on calculated measures
Hi - I want to add shapes/cards such that it changes color based of the value of another measure. In the below example (attached pic) the card is a in the shape of small circle. All i want is the c...
Hi sujitjena
Add the [Conditional Format] measure to a "Advanced card" visual, then set the Format->Conditional option as below
Change the measure to below:
Conditional Format = IF([GP Deployed FYTD]<[GP Deployed LYYTD],1,0)Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak : I already tried this, but its a range that controls the change of color. I need more of a dynamic set up where the comparison value changes month on month.In my PBIX file the card i want to be colored is the 3rd one (Conditional Format) and not the (FYTD or LYYTD).
If you see the measure i created (Conditional Format) - I am trying to set it up based on the values in GP Deployed FYTD and GP Deployed LYYTD. Can we control the color coding this way?
sujitjena, I used that measure in conditional formatting. Is there something else we are looking for.