page level filtering

[Anonymous]

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

[afekri1]

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.

[shafiz_p]

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!!

[Anonymous]

Thanks for replying

But by one click this will not work I guess, like same as in Qlik and more over when we drill through also when we go to Main page that filter will disappear

So please let me know if you have any idea on this

Thanks

[Anonymous · Accepted solution]

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.