cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArtFi Frequent Visitor
Frequent Visitor

Hide slicer on dashboard

Is there a possibility to hide a slicer on a dashboard but still be able to select a certain option. The goal would be to print the dashboard for multiple users, with them only seeing the information that's relevant for them, so that excludes the slicer itself. Thank you!

2 ACCEPTED SOLUTIONS

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

Re: Hide slicer on dashboard

@ArtFi I think only on reports not dashboards. Use report level filter or page level filter to filter for all the visuals.

View solution in original post

Microsoft v-micsh-msft
Microsoft

Re: Hide slicer on dashboard

Hi ArtFi,

 

In Power BI service, and Desktop, there is no function available currently to hide a slicer. If the purpose here is to print the report (or the dashboard), then we may edit the filter settings under report, Check: Add a filter to a Power BI report (in Editing view).

In addition, as a workaround, we may try to format the front and header with white color, change the orientation to “Horizontal”,  this would somehow “hide” the items,  the value would be highlighted when mouse cursor on it, when selected, it will only show the selected item:

4.PNG

 

Page level filters would apply the filters to all the charts on the same page, if you would like to change the same filter for all charts on the same page, then use Page Level filter. Check the article I share above for the difference about Filters.

If any further assistance needed, please post back.

Regards

 

 

View solution in original post

6 REPLIES 6
ankitpatira Super Contributor
Super Contributor

Re: Hide slicer on dashboard

@ArtFi You can use filters for this scenarios which lets you filter but when you print dashboard they are not printed.

ArtFi Frequent Visitor
Frequent Visitor

Re: Hide slicer on dashboard

@ankitpatira I see, but is it possible to use it on the dashboard (or only in the report), and can you have one filter for all charts,? Otherwise I'd have to click each chart separately, which is not very handy!

ankitpatira Super Contributor
Super Contributor

Re: Hide slicer on dashboard

@ArtFi I think only on reports not dashboards. Use report level filter or page level filter to filter for all the visuals.

View solution in original post

Microsoft v-micsh-msft
Microsoft

Re: Hide slicer on dashboard

Hi ArtFi,

 

In Power BI service, and Desktop, there is no function available currently to hide a slicer. If the purpose here is to print the report (or the dashboard), then we may edit the filter settings under report, Check: Add a filter to a Power BI report (in Editing view).

In addition, as a workaround, we may try to format the front and header with white color, change the orientation to “Horizontal”,  this would somehow “hide” the items,  the value would be highlighted when mouse cursor on it, when selected, it will only show the selected item:

4.PNG

 

Page level filters would apply the filters to all the charts on the same page, if you would like to change the same filter for all charts on the same page, then use Page Level filter. Check the article I share above for the difference about Filters.

If any further assistance needed, please post back.

Regards

 

 

View solution in original post

Ermin Frequent Visitor
Frequent Visitor

Re: Hide slicer on dashboard

Hi,

There is one more option to hide a slicer. You can position the slicer outside of the report sheet. This is what I do.

 

  1. Increase the page size of the report (I usually increase the page height: 3400)

Page Size 1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. Position your slicer on the bottom of the page (the purple boxes beow is the slicer)

 

Filter View.jpg

 

3. Reduce page size (Height 3200)

 

 Page Size 2.png

 

  1. The slicer has disappeared

 

Please note, after this you don’t see your slicer anymore and you cannot change the value. You need to find a way to set a default value for the filter (I.e. to the current month, or similar)

Highlighted
Lydia_Aidyl Visitor
Visitor

Re: Hide slicer on dashboard

You need to click selection pane, then click on the slicer and see on the selection pane which one it is. Then click on the hide icon.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors