Forum Discussion
Paginated Drill through
Hi,
I am facing a challange in my solution, I have a Power BI Dashboard which has multiple KPIs, e.g;
1. A Card--> which has total orders
2. A Card--> which has total open orders
3. A card --> which has total rejected orders.
etc.
I am filtering all these Cards and other visuals of the dashboard thorugh a slicer of customer. Now i have a paginated report built on Report builder which has detail of these oreders like open orders rejected order etc.
I want to provide feature so that if user comes on dashboard and selectes customer through slicer, cards will filter based on that, now i want to giver feature to drill down into paginated report based on the selection of customer from slicer and the card which user has clicked.
I could integrate the paginated report into dashboard but not able to filter the report based on the slicer and card selection of my dashboard.
Please help.
Thank for the reply from GilbertQ.
Hi manas87 ,
If you want to filter paged reports by slicer, try to add parameters to your paginated report that correspond to the slicers in your Power BI report. These parameters will allow us to filter the data in the paginated report. You can get specific steps in the following link:
Solved: How to get the data from PBI table to a Paginated ... - Microsoft Fabric Community
One thing to note here is that the slicer only filters the data in the paged report, there will be no context, and you will need to set the content and data to be displayed in Report Builder.
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
2 Replies
Thank for the reply from GilbertQ.
Hi manas87 ,
If you want to filter paged reports by slicer, try to add parameters to your paginated report that correspond to the slicers in your Power BI report. These parameters will allow us to filter the data in the paginated report. You can get specific steps in the following link:
Solved: How to get the data from PBI table to a Paginated ... - Microsoft Fabric Community
One thing to note here is that the slicer only filters the data in the paged report, there will be no context, and you will need to set the content and data to be displayed in Report Builder.
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
