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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Instead of using the Card visual, use the KPI visual

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors