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.
Hi all,
I have a report with two pages.
On the first page , there is a bar graph that shows " #salesman by department".
On the second page, I have the details of all the salesman. This second page is hidden and users can go to this page only when they drillthrough on the bar graph.
At present, users of the report can see the drillthrough option on each bar and they are able to drill-through and see the details of salesman for each department in the bar graph.
Now, what I want is, if a user is from Department 'A', he should be able to drillthough on Bar 'A' , but he should not be able to drillthorugh on other departments.
How can I achieve the above?
Thanks
Hi @WorkswithData ,
We did not find a solution to prevent user drill-through to another page based on some rule, but we can blank the visual after user drill through from the other department .
We can create a measure such as following and use it in a visual filter as a workaround
Measure = CALCULATE(COUNTROWS('UserTable'),FILTER(ALLSELECTED('UserTable'),[Email]=USERPRINCIPALNAME()))+0
Sales table
User table
When user has id =2 drill through from department A, he can not see the content
But if he drill through from department B, he can see content in page 2.
We also suggest use Row-Level security (RLS) to restrict data access for given users.
Best regards,
Awesome. I will try this out and let you know if this solves.
Hi @WorkswithData ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
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.