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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
karma
Advocate II
Advocate II

Dynamic Card Visual's Color

Is it possible to change the background colour of a card visual dynamically based upon the measure/column that we are using in the card?
 
Eg- if the value is below 10 i want to display Red colour
If it is 20 then green etc
1 ACCEPTED SOLUTION
truptis
Community Champion
Community Champion

Hi @karma ,

Yes, it can be achieved using conditional formatting of the visual.

Please try the below steps:
1) Click on your card visual and go to your format options
2) In format, click on background colour
turn the toggle on and click on fx (refer screenshot below)

truptis_3-1647509468819.png


3)After clicking on fx, a window would pop up:
in format style- Select Rule
what field should we base it on? - Select your measure/calculation
In rules give your conditions:
eg- if value > 10 then select your desired colour(Refer screenshot below):

truptis_4-1647509502582.png

 

Then click on OK.

@karma  if this helps you then please mark it as a solution & hit the thumbs up. Thank you.

 

 

View solution in original post

3 REPLIES 3
truptis
Community Champion
Community Champion

Hi @karma ,

Yes, it can be achieved using conditional formatting of the visual.

Please try the below steps:
1) Click on your card visual and go to your format options
2) In format, click on background colour
turn the toggle on and click on fx (refer screenshot below)

truptis_3-1647509468819.png


3)After clicking on fx, a window would pop up:
in format style- Select Rule
what field should we base it on? - Select your measure/calculation
In rules give your conditions:
eg- if value > 10 then select your desired colour(Refer screenshot below):

truptis_4-1647509502582.png

 

Then click on OK.

@karma  if this helps you then please mark it as a solution & hit the thumbs up. Thank you.

 

 

Thank you @truptis 

That worked just as required.

 

Thanks for the detailed reply. Cheers!!!

coskuersanli
Resolver III
Resolver III

Hi @karma 

You can use conditional formating 🙂

coskuersanli_0-1647509495199.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.