Forum Discussion
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 color to change to red when its greater than the card above it or green when less. For this i have also created another Measure only for the small circle that is given below:
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.
8 Replies
Hi sujitjena
To get the icon, create a measure and format the color of the icon.
Measure = UNICHAR(9679)icon list
http://xahlee.info/comp/unicode_geometric_shapes.html
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/882970amitchandak : 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.
