Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ahassan44
Frequent Visitor

Setting the Default Value of a Slicer based on the User's name/login

I have to 25 users that will review the dashboard, and I want each of them to be defaulted to his group/Office (Without secruity resrictions). I was wondering if there is a way to do that?

5 REPLIES 5
RGI
Helper III
Helper III

Hi @ahassan44 

 

We have the same requirement and all solutions appear to be kludgy workarounds.

How did you eventially solve this?

 

tia

RGI

 

ahassan44
Frequent Visitor

I just asked the end users to use the slicer every time they log in as it is only one search slicer. Meanwhile, I changed the setting to make sure the dashboard doesn't save on the end-user selection.

 

The other solution would be if you create a RLS tables, and limit the end user view based on their name or GEO

v-chuncz-msft
Community Support
Community Support

@ahassan44,

 

By the way, you may leave a comment and vote this idea up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Perhaps. You might be able to do something with a table of user names, SELECTEDVALUE and USERPRINCIPLE name. Kind of like a What If parameter.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi Greg,

 

I want to achieve this function. I have a user name column, whenever the user logs in to pbi only his name should be filtered and all other things should show up based on his username alone.

 

How to achieve this?

Please help.

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.