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.
If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
amitchandak : I have shared the PBIX file at below link. I am basically trying to change the color of the card based on the measure "Conditional Formatting". Not sure if this is possible.
https://www.dropbox.com/s/7hdvaak788gqm89/PBIX%20View.pbix?dl=0
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?
