topic Conditional formatting based on fieldvalue in Advance Card in Developer

Conditional formatting based on fieldvalue in Advance Card

Vinod_G_245 — Tue, 31 Jan 2023 17:12:20 GMT

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.

Re: Conditional formatting based on fieldvalue in Advance Card

Anonymous — Wed, 01 Feb 2023 06:13:15 GMT

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

Re: Conditional formatting based on fieldvalue in Advance Card

Anonymous — Tue, 07 Feb 2023 06:40:31 GMT

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