Forum Discussion
page level filtering
Hello all,
I am trying to replicate same qlik sense filtering functionality across all the pages
1. My sheet without any filters
2. Selected C_CNTRY= 'US' in bar chart, then it filtered in table chart also automatically
3. The C_CNTRY Filter will carry forwarded automatically in next page also without adding any extra functionalities and shown only those I_SUPLR_LOC_SUFF related to C_CNTRY='US'
This will be applicable to all types of charts...
How can I get same in Power BI, a filtering across all pages in visual level not in slicer level
Please help
Thanks in advance
Thank you shafiz_p
Hi, Anonymous
Power BI doesn't have the ability to replicate qlik sense directly. But you can use Drill Through with Sync Slicer to achieve something similar:
How to use the synchronous slicer with drillthroug... - Microsoft Fabric Community
If you're not familiar with Drill-through, you can learn more about it by clicking on the link below:
Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn
Create a drillthrough button in Power BI - Power BI | Microsoft Learn
Power BI – How to add Drill Through to Reports - Xelplus - Leila Gharani
With these features provided by Power BI, you can get as close to your needs as possible.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous You can use sync slicer but you don't want this. So, you can use drillthrough, which is very useful. Also, you can use report level filter, "Filters on all pages" on filter pane.
Hope this answered your question!!Thank you shafiz_p
Hi, Anonymous
Power BI doesn't have the ability to replicate qlik sense directly. But you can use Drill Through with Sync Slicer to achieve something similar:
How to use the synchronous slicer with drillthroug... - Microsoft Fabric Community
If you're not familiar with Drill-through, you can learn more about it by clicking on the link below:
Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn
Create a drillthrough button in Power BI - Power BI | Microsoft Learn
Power BI – How to add Drill Through to Reports - Xelplus - Leila Gharani
With these features provided by Power BI, you can get as close to your needs as possible.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you're using a slicer for your filter, you can use the sync option to sync this slicer across all pages.
If you're using the filter pane for your filter, place your desired fields in the page filter.
