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. Despite my own efforts and internet search I'm still not capable. So I can use some help šŸ˜‰

 

Thanks in advance!

 

PZU 

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

4 Replies

  • 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!

      • Fowmy's avatar
        Fowmy
        Super User
        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