Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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.

Filters 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

detailed 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.  

  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

     

     

     

     

     

     

     

     

    Br,

    T

     

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

     

     

     

     

     

     

     

     

    Br,

    T

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        Anonymous
        Not applicable

        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