Forum Discussion

pavan2's avatar
pavan2
Frequent Visitor
8 years ago
Solved

How to display static text on PowerbI visual if data got filtered out with filters

Hi All,

 

I had customer requirement for not displaying blank viusal if data got filtered out in PowerBI. How can i get Static text (No data available with that filter) to be displayed on it. Please suggest me how to over come this.

 

Thanks

Pavan

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Depends on what your visual is displaying, is it a card visual displaying text or some kind of chart? If it is a chart, one option might be to overlay a card visual on top of it and use a measure like this:

     

    Measure = IF(COUNTX(Table1,[Column1])=0,"No Data","")

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Depends on what your visual is displaying, is it a card visual displaying text or some kind of chart? If it is a chart, one option might be to overlay a card visual on top of it and use a measure like this:

     

    Measure = IF(COUNTX(Table1,[Column1])=0,"No Data","")