Forum Discussion
Solved
Conditional formatting based on fieldvalue in Advance Card
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 ac...
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
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