cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WorkswithData
Frequent Visitor

Help with hiding data in drill-through

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 

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Help with hiding data in drill-through

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

13.jpg

 

User table

14.jpg

 

When user has id =2 drill through from department A, he can not see the content

 

15.jpg

 

16.jpg

 

But if he drill through from department B, he can see content in page 2.

17.jpg

 

We also suggest use Row-Level security (RLS) to restrict data access for given users.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WorkswithData
Frequent Visitor

Re: Help with hiding data in drill-through

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

Community Support
Community Support

Re: Help with hiding data in drill-through

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,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Kudoed Authors