Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi all,
is it possible to create a default filtered view based off the user that logs in?
For example, I am using RLS to filter the report based off what customer ID's the sales rep is tied to. a customer has sales in multiple Geos and theres a sales rep for each Geo. However when the reps login to the report they can slice of the different Geos throughout the cusomter. Each rep has a "home Geo" and I want to have the home geo auto filtered when they login (but still have the ability to slice to other Geos). Is this possible?
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Yes, a default slicer is currently unavailable.
However, the temporary workaround is to create a bookmark to set up default filters.
Set Up Default Filters in Power BI - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Sorry for bothering you...
But did I answer your question ? Please mark my reply as solution and more people will find it quickly. Thank you very much.
Best Regards,
Stephen Tao
@Greg_Deckler you have any idea on this? I saw a tread similar to this that you responded: "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."
Hi @Anonymous ,
Yes, a default slicer is currently unavailable.
However, the temporary workaround is to create a bookmark to set up default filters.
Set Up Default Filters in Power BI - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
This video maybe useful-
(1497) Customize default values for each user in Power BI reports - YouTube
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 33 | |
| 33 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 68 | |
| 67 | |
| 45 | |
| 30 | |
| 28 |