Conditional Formatting based on calculated measures

[sujitjena]

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:

Variance Colour = IF([Growth %]>[LC %],"#FF6966","#297D6F"). However, this doesnt work. Any suggestions or alternatives?

I tried conditional formatting but it is dependant on manual input for minimum or maximum values and i want a dynamic set up. Not sure if there is a way.

[v-juanli-msft]

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
Maggie

Community 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]

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-tr...

[sujitjena]

@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

[amitchandak]

Hope this is what you need. There is three vertical . in backgroud color, Only appear when take mouse there. The click and choose formatting.

[sujitjena]

@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?

[v-juanli-msft · Accepted solution]

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
Maggie

Community 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.

[sujitjena]

@v-juanli-msft : Thanks Maggie, I think this is what i was looking for. Advanced card worked.

[amitchandak]

@sujitjena, I used that measure in conditional formatting. Is there something else we are looking for.