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!

    • 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

      • PZU_DGW's avatar
        PZU_DGW
        Regular Visitor
        4 years ago

        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