Forum Discussion

sujitjena's avatar
sujitjena
Resolver I
6 years ago
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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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's avatar
sujitjena
Resolver I
6 years ago

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