Forum Discussion

ArtFi's avatar
ArtFi
Frequent Visitor
10 years ago
Solved

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...
  • ankitpatira's avatar
    ankitpatira
    10 years ago
    ArtFi I think only on reports not dashboards. Use report level filter or page level filter to filter for all the visuals.
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    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:

     

    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

     

     

Ermin's avatar
Ermin
Advocate II
9 years ago

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)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

 

3. Reduce page size (Height 3200)

 

 

 

  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)