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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
hansolo
Helper I
Helper I

Hide Values in Slicer

 

 

 

 

 

Trying to design some "buttons" by augmenting slicers. Please see below. Is there any way I can limit values in a slicer? For instance, I just want there to be the current week, last week, etc ... not the deselect or the blank option. 

 

 

Capture.PNG

1 ACCEPTED SOLUTION
chrisu
Responsive Resident
Responsive Resident

There is a bug that disables visual-level filters for slicers.  You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer.  The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.  

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

How are you creating the values. e.g.  last 7 days, WTD, for the slicer? I'd like to do something similar with Google Analytics data. Feel free to msg me directly so this thread doesn't go off track.

 

Thanks,

Jeff

chrisu
Responsive Resident
Responsive Resident

There is a bug that disables visual-level filters for slicers.  You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer.  The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.  

This solution isn't working for me in Version: 2.38.4491.282 64-bit (August 2016)

chrisu
Responsive Resident
Responsive Resident

Yes, this workaround was disabled a few months ago.  Please vote on the following idea to bring it back:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15091614-can-no-longer-filter-a-s...

@chrisu amazing. thank you. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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