Slicer with empty values

[frankherfert]

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

[Greg_Deckler]

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

[frankherfert]

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.