single Select reset

[Anonymous]

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 

[Anonymous · Accepted solution]

Parvinder ,

Thank you

Oded Dror

[v-juanli-msft]

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]

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]

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

[Anonymous · Accepted solution]

Parvinder ,

Thank you

Oded Dror

[parry2k]

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

[parry2k · Accepted solution]

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

[parry2k]

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