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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)