For demonstration purposes, I have created two sample tables.
Sales
Role
Below is the Power Query for both tables.
let
Source = Table.FromRows(Json.Document(Binary.Decomp...
Updated 6 years ago
Version 6.0
Blog Post
Very well thought.
I had a different senario and your post gave me a head start. For example, [email protected] should be able to navigate to Japan and United States only whereas user2 should be allowed to navigate to United States and France.
I modified your pbix file and came up with a solution.
I used a slicer aligned in horizontal and button for page navigation.
Next I changed the page_navigation measure to the below and assign it to the button created for page nav-
In order to filter the data on the slicer I created a role-
After deploying the solution I assign users to the role. For test purpose I will manually assign username as [email protected] in the solution itself.
Thank you.
Do check my other approach.