Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have one excel sheet with the following column names..
shortname with values north,east,west,south ---- [which contains list of all our sales areas]
category with values motors, pumps,panels ----- [ list of items sold]
I have created a RLS using dax with [Shortname] in {"North","west"} and applied it for a user in BI dashboard.
Now for the same user i need to give access only to [Category] {"motors"}.
Kindly post me the dax command for this .
I am a beginner in BI dashboard..
Mate, you have to have a mapping table from the username (USERNAME() or PRINCIPALUSERNAME()) to the categories you want the user to be able to view. Then and only then can you create what you want. Please try to google RLS in DAX if nobody gives you a ready-made solution. There are many blogs out there treating this topic.
Best
Darek
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |