Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Default Filter Slicer

Hi,   My slicers aren't defaulting to what I saved them as before publishing to server. How do I get my Power BI Server Dashboard to default to the slicer/filter values I want? They change every ti...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 
You can switch on the option " Don't allow the end user to save filters on this report." from the desktop/service, and it will always keep the selections the report published with.
The steps to apply from the desktop :

 

From service :

 

If my answer was helpful please give me a Kudos and accept as a Solution.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ritaf1983,

 

Thanks for the solution. Do you know if I can do the same thing for a map drill down? I am trying to publish the map with the drill mode on feature, but in Power BI Published report service, it doesn't default to "Drill mode on".

 

Thanks!

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 

    Yes, the same feature also retains the drill level.
    I recorded the screens showing how it works.
    You can download the media file from the link :
    https://drive.google.com/file/d/1jDhcSsZEtaeBBppGI2FUy-9Ihj12moRS/view?usp=sharing

    It's important to note that sometimes these things get a bit stuck, partly due to the browser's cache. In such cases, you simply need to refresh the screen with F5.

    If my answer was helpful please give me a Kudos and accept as a Solution.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Ritaf1983,

       

      I watched your video but what I'm asking is for the "Drill Mode: ON" to stay toggled on. In yours, you still have to toggle that on to do so appropriately.

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User
        2 years ago

        Hi Anonymous 
        There is no option to save drill mode, only the hierarchy level/filters/slicers.

        If my answer was helpful please give me a Kudos and accept as a Solution.