cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WorkswithData Frequent Visitor
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
Community Support Team
Community Support Team

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
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 Team
Community Support Team

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors