Forum Discussion

Valnus's avatar
Valnus
Icon for Helper II rankHelper II
4 years ago
Solved

Filter to display None

Hi 


I have a pie chart that I use to display if during a time priod there are any red or Orange flags for the time period ( slicer ) and Company ( slicer ) 

This works as intended but, When there are no flag's the visual is empthy. I would like to display something to indicate No Risk. 

I assume I need to create a meassure for this.  Any help on the dax. I am referancing two colums for two diffrent tables 


  • Valnus , when the value is blank you can make the transparent background . Keep a text box behind that will  show

     

    Use a measure in background using fx field value

     

    if(isblank[measure]) , "#FFFFFF00", "#FFFFFF")

1 Reply

  • Valnus , when the value is blank you can make the transparent background . Keep a text box behind that will  show

     

    Use a measure in background using fx field value

     

    if(isblank[measure]) , "#FFFFFF00", "#FFFFFF")