Conditional formatting based on fieldvalue in Advance Card

[Vinod_G_245]

Hi Team,

we are using advanced card visual in Power BI, for that value we want to apply conditional formatting.

Example: If actual value > Buget value then the numbers should be in Green, if the actual value is between 95% to 100% of budget value then it is Amber, if the value is actual value is <95% then it is red.

Note: This can be achieved in  table and matrix visual by selecting field measue, for business requirement we are using advance card.

[v-yiruan-msft]

Hi @Vinod_G_245 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[v-yiruan-msft · Accepted solution]

Hi @Vinod_G_245 ,

As checked the setting options of advanced card, there is no conditional formatting option for the card value. As an workaround, you can create a default card visual to replace it.

Then create a similar measure as below and apply the conditional formatting for the callout value of card as below screenshot...

Conditional formatting =
IF (
    [Actual] > [Budget],
    "Green",
    IF ( [Actual] >= 0.95 * [Budget] && [Actual] <= [Budget], "Amber", "Red" )
)

Best Regards