Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

single Select reset

Hi there,

 

I have a report based on RLS with two slicers one Department  and second Jobs

Users can see only jobs which they belong to theirs department.

Everything works just fine (for example user A can see jobs belong to Dept 10 and user B can see jobs belong to dept 11)

The problem start when I modify the Job slicer to single select for example if I publish the report I need to select at least one job which belong to department that only users with RLS can see.

For example I published a report with Department = ALL and Job 10 

When user B try to browse the report he / she see an empty report because theris department is not on theirs RLS list.

 

My question - how do I reset the single select slicer so on the first time user can see theris department and jobs? 

 

Thanks,

Oded  Dror 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Parvinder ,

     

    Thank you

     

    Oded Dror

     

  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous I wrote a blog post for this which you can find it here and also there is a sample pbix file to download for you to use in your report.

     

     

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous I see what you are saying, it is going to be a problem because when you set a single slier, it selects a value. In this case you need to add a value in slicer table called "All" which should be selected as a default and when users are switched, by default "ALL" is selected since it will be available for every user regardless what department data they can see. I don't see any other workaround for now.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    There is no such feature in current version of Power BI.

    You could vote for a similar idea or this idea.

    Here are some workarounds:

    https://community.powerbi.com/t5/Desktop/Force-a-selection-in-a-drop-down-slicer/td-p/431735

    https://community.powerbi.com/t5/Desktop/Forced-value-in-slicer/td-p/515143

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Maggie,

      Thank you for your response but it not solve my issue.
      Single select slicer can't start on load page event with null value like programming language (radio button for example)
      It has to fix with Microsoft development team. (maybe in a few months)

      How to I close this incident without having to mark it as solved?


      Thanks,
      Oded Dror

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous solution I proposed will need some development which I will as part of my experiment. It is great request and need to be fixed.