Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dinovic
Frequent Visitor

Conditional Formatting Card

I have a measure displayed in a card visualization.  The measure is ([Revenue January] / [Revenue December]) - 1 , displaying the %diff this month compared to previous month. Now, I would like this Card visual, or any other available custom visual, to be displayed in Green or Red font, depending on the value. A very easy thing to do in excel, but cant seem to find any decent solution in Power BI.

Anyone know how to solve this? Is there any custom visual out there that solves this problem?

Thanks

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@dinovic

Try the Card with States Custom Visual I think you'll like it

 

I personally use it a lot and now with the latest release its even better!

 

However download it from here to make sure you have the latest version

http://okviz.com/card-with-states/

 

Good Luck! Smiley Happy

View solution in original post

3 REPLIES 3
shaunwilks
Helper V
Helper V

Probaby not around when this was posted but there is a "Advance Card" in the marketplace that has some controlling over the colouring given specific conditions.

 

It seems to work pretty well so far.

You get to specify a Measure for the display and set a different measure for the condition.

 

So in my case iver used a UNICHAR character in the display, and the numerical value in the condition.

Means I display up arrows, down arrows or side arrows, and then can change the colours of those unichar characters very easily in the conditions section of the control.

Sean
Community Champion
Community Champion

@dinovic

Try the Card with States Custom Visual I think you'll like it

 

I personally use it a lot and now with the latest release its even better!

 

However download it from here to make sure you have the latest version

http://okviz.com/card-with-states/

 

Good Luck! Smiley Happy

dkay84_PowerBI
Microsoft Employee
Microsoft Employee

Instead of using the Card visual, use the KPI visual

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.