cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Parvinder ,

 

Thank you

 

Oded Dror

 

View solution in original post

@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.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

7 REPLIES 7
v-juanli-msft
Community Support
Community Support

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
Not applicable

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

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Parvinder ,

 

Thank you

 

Oded Dror

 

@Anonymous I think I found the solution for this, will share it soon. cheers!!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@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.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User
Super User

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.