Forum Discussion

PZU_DGW's avatar
PZU_DGW
Regular Visitor
4 years ago
Solved

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. De...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    4 years ago

    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

Fowmy's avatar
Fowmy
Super User
4 years ago

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.

 

PZU_DGW's avatar
PZU_DGW
Regular Visitor
4 years ago

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!