Forum Discussion

frankherfert's avatar
frankherfert
Advocate I
10 years ago

Slicer with empty values

Hello,

 

I'm using multiple slicers in some of my pages.

Most just work fine (date slicers for example) while others show a lot of entries that have no values for the associated visuals.

 

Lets say I want to filter sales by clients. I get a list with 100 clients in my source file but only 60 of them actually bought something this month. I can't link them to the sales table while importing to omit empty values unfortunately as they come from flat files.

Excel shows these irrelevant values in a greyed-out color in its slicers or even better, does not show them at all when you select the specific option in the right click menu.

 

Do you know of a way to get the same behavior in PowerBI? This is counterintuitive to our report users as they click through the different clients / products / categories and just find empty values while months without data dont show up.

 

Thank you

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Try using a page level filter to filter out your sales measure for blanks or zeros perhaps?

    • frankherfert's avatar
      frankherfert
      Advocate I
      10 years ago

      Thank you for the suggestion.

       

      Unfortunately, this does not work.

       

      I cant use my measures as page level filters but the original field can be used. When using "is not zero" or "is not blank", nothing changes in the report - even when selcting the filter options where measures clearly dont get any values.