Dynamically change the single select value of a slicer based on a group to which user has access to.

[Optimusprime_25]

Hi Team,

@amitchandak , @v-rongtiep-msft 

we have 3 different report users

• HQ
• Region
• Country

We also have two groups which are "ABC" and "XYZ"

Above users may have access to only group either "ABC" or "XYZ" or both groups.

We have a Group slicer in the report, which we are publishing it with Single Select option as ABC.

When any user logs in who have access only to ABC or both groups they can be able to see the data.

We are facing issue when the user logs in who has access only to XYZ group, they cannot see the data. They are able to see blank visuals why because we have published the report with single select option by selecting ABC as default filter.

Can we change the single select group filter value based on user's access to the group.

Note: This is the user requirement, we cannot change the single select to multi select and select all options

could you please let me know how to proceed on this.

Thank you.

[Optimusprime_25 · Accepted solution]

Hello All,

We have resolved this issue of dynamically changing the slicer default value for which user has access.

We have used custom visual  Chiclet Slicer in the report. By which we can force the default value in the slicer for whoch the logged in user has.

Frome the above requirement when the user who has access to ABC group then they will see ABC as their default slicer value. Same goes with the users who has access to XYZ group. When the users who has access to both ABC and XYZ groups, they will see ABC as their default value in the slicer.

Earlier with the normal slicer visual, we couldn't deselct the slicer value, but now it has been eradicated by using chiclet slicer.

Thanks.

[hassan_tariq247]

Thanks for the custom visual suggestion. That really helped.

[Sahir_Maharaj]

Hello @Optimusprime_25,

Yes, it is possible to change the single select group filter value based on the user's access to the group. One way to do this is to use role-based security in Power BI.

First, you can create two roles in the Power BI report: one for users who have access to the "ABC" group, and another for users who have access to the "XYZ" group. You can then assign users to these roles based on their group access.

Next, you can create two versions of the report, one for each role. In the "ABC" report, the group slicer will be set to "ABC" by default, while in the "XYZ" report, the group slicer will be set to "XYZ" by default.

Finally, you can use Power BI's row-level security (RLS) feature to restrict access to the appropriate report version based on the user's role. This will ensure that users can only see the report version that corresponds to their group access.

Hope this helps!

[Optimusprime_25]

Hello @Sahir_Maharaj 

Thanks for your prompt response.

Our requirement is to have only one report, not different versions of the report.

We have already setup RLS in the report based on Group's ABC, XYZ and both ABC&XYZ.

Our requirement is when the HQ user(ABC & XYZ) opens the report they should see the report with default single select filter as ABC and they should also see the XYZ value in the filter to change or to see XYZ data in the report.

Whereas, when ABC users opens the report they should see the report with ABC data and similarly with the XYZ as well.

Our main challenge is to dynamically change the selected slicer value.

Our challenege is to deselct the selected filter value.

Thanks in advance.