Help with hiding data in drill-through

[WorkswithData]

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 

[v-lid-msft]

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,

[WorkswithData]

Awesome. I will try this out and let you know if this solves.

[v-lid-msft]

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,