Forum Discussion
Conditional Formatting based on calculated measures
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.
Hope this is what you need. There is three vertical . in backgroud color, Only appear when take mouse there. The click and choose formatting.
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?
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.v-juanli-msft : Thanks Maggie, I think this is what i was looking for. Advanced card worked.
sujitjena, I used that measure in conditional formatting. Is there something else we are looking for.