cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Drill through concept

Hi I have a report style which i implemented on Datazen and now i want to implement the same functionality on Power BI by using drill through or any other based on feasible on power Bi. So kindly help me on this.

 in a power Bi report i have 2 pages.. 1st page contains filters and here i have to apply the filters and i have to see the detailed report in 2nd page based on 1st page filters based on drill through insted of report level filter.

filters1.PNGFilters page

senario will be like once i apply the filters, i have to click on the Report button which i colored in Red on image..if i click in that button it will take me into the report page automatically and able to view the detailed report like below

report1.PNGdetailed report based on filters

So kindly help me to achive this and anyone can you kindly implement the same with dummy data and shared with me the .pbix file to understand better.

 

Thanks in advance.  

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

Re: Drill through concept

@Anonymous,

 

I'll make a very quick pbix where you can see the basic functionality. It'll use a button directing to bookmark (the second page) and it will sync all the slicers to the next page without making them visible.

 

Here it is: dummy data pbix

Have a look through the sync slicers and bookmarks options from the View tab.

sync&bookmark.PNG

 

 

 

 

 

 

 

 

 

Br,

T

 

Anonymous
Not applicable

Re: Drill through concept

@Anonymous

The image in my previous post should ahve everything you need.

 

  • Check the bookmark settings in my previous picture and uncheck 'Data'
  • Check that the slicers are syncing with both pages

 

Br,

T

3 REPLIES 3
Anonymous
Not applicable

Re: Drill through concept

@Anonymous,

 

I'll make a very quick pbix where you can see the basic functionality. It'll use a button directing to bookmark (the second page) and it will sync all the slicers to the next page without making them visible.

 

Here it is: dummy data pbix

Have a look through the sync slicers and bookmarks options from the View tab.

sync&bookmark.PNG

 

 

 

 

 

 

 

 

 

Br,

T

 

Anonymous
Not applicable

Re: Drill through concept

Hi t_R, thanks for the solution, i have implemented the same but the pbm is the data was not syncing on report page based on filter condition from filters page.

 

Can you kindly suggest me on this....Thanks in advance.

Anonymous
Not applicable

Re: Drill through concept

@Anonymous

The image in my previous post should ahve everything you need.

 

  • Check the bookmark settings in my previous picture and uncheck 'Data'
  • Check that the slicers are syncing with both pages

 

Br,

T