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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
PZU_DGW
Regular Visitor

Conditional fill shape color

Is it possible to conditional fill de color of a shape depending on the value of a measure? I'd like to have a green fill of a square when the measure is not blank and a red fill when it is blank. Despite my own efforts and internet search I'm still not capable. So I can use some help 😉

 

Thanks in advance!

 

PZU 

1 ACCEPTED SOLUTION

@PZU_DGW 

IF you are using different measures, then you need to apply them individually. 

There is a way to automate by using Calculation Group in Tabular Editor

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Fowmy
Super User
Super User

@PZU_DGW 

Make sure you have the latest Power BI desktop version installed. Create a measure like the one below. 

CF Measure = IF( ISBLANK([Yourmeasure]) , "Red" , "Green" ) 

 Under Fill, choose the fx and apply the measure under filed value.

Fowmy_0-1634465052450.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Dear Fowmy,

 

Thanks for your reply and it works..but there's a catch. Unfortunatly is do have 9 buttons in my report (please dont't ask me why). Is there a way I do not have to make 9 separate measures to check the value? I already guest that I will make 2 color-measures (for with and without value) so i can change the colorstyle easily.

 

Thanks so far!

@PZU_DGW 

IF you are using different measures, then you need to apply them individually. 

There is a way to automate by using Calculation Group in Tabular Editor

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

I've read about Calculation Groups, but for now I will make 9 separate measures. Thanks for the help (again!). I will take the time to figure out calculation groups later.

 

Greetings,

 

PZU

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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