Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
frankherfert
Advocate I
Advocate I

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

----------------------------------------------------
New to DAX/Power BI. Not a native speaker.
2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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.

----------------------------------------------------
New to DAX/Power BI. Not a native speaker.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.