Forum Discussion
Slicer dynamic selection defaulted based on user login
I have a use case where:
The slicer value in the report should be defaulted to the logged in user when they open the report, and also the user should be able to select the remaining data points if required.
Eg: I have a table User with columns Email and Office and another table Office with Office name and other details.
I need to create a slicer of Office Name and these 2 tables are joined on office. When the user logs in with email address, they should have the slicer value defaulted to the office name from User table.
How can this be achieved?
Hi avgavg
I'm inclined to believe this is not possible.
As Measures can't be used for a slicer, our only dynamic options are Calculated Columns and Tables. However, these do not support the use of USERPRINCIPALNAME() / USERNAME() / CUSTOMDATA() which would otherwise be used to build dynamic functionality based off of the logged in user.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Dataavgavg , As below mentioned by super user this requirement is not possble. It's important that our product team hears about this directly from users like you, who are deeply engaged with the platform and rely on it for essential operations, these insights will undoubtedly contribute to a better experience for all users.
I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. Feedback submitted here is often reviewed by the product teams and can lead to meaningfulThanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
3 Replies
- Jonvoge
Most Valuable Professional
Hi avgavg
I'm inclined to believe this is not possible.
As Measures can't be used for a slicer, our only dynamic options are Calculated Columns and Tables. However, these do not support the use of USERPRINCIPALNAME() / USERNAME() / CUSTOMDATA() which would otherwise be used to build dynamic functionality based off of the logged in user.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill DataAre you aware of any other work around to solve this use case using Power BI?
Any custom visual which you are aware of?
v-prasareCommunity Support
avgavg , As below mentioned by super user this requirement is not possble. It's important that our product team hears about this directly from users like you, who are deeply engaged with the platform and rely on it for essential operations, these insights will undoubtedly contribute to a better experience for all users.
I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. Feedback submitted here is often reviewed by the product teams and can lead to meaningfulThanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
