Slicer Filtering with URL query string parameter

[smpa01]

I am following this but it is not showing the filtered value to appear on slicer dropdown like it shows the filtered data on the table viz.

Current

https://app.powerbi.com/groups/ws_id/reports/report_id/page_id?filter=tbl/region eq 'uk' and tbl/year eq 2025

What I was hoping the URL filtering to return

Is there a workaround? To be absolutely clear, I want to keep on using dropdown yet achieve the end goal if there is a way.

base data

select 'usa' as region, 2024 as year, 100 as value 
union all
select 'usa' as region, 2025 as year, -100 as value 
union all
select 'uk' as region, 2024 as year, 200 as value 
union all
select 'uk' as region, 2025 as year, -200 as value 

Current Slicer settings

thank you in advance.

[V-yubandi-msft]

Hi @smpa01 ,

Just following up since we haven't received a response. Did the solution we provided resolve your issue? If you need any further assistance, please let us know. We value your feedback and look forward to hearing from you.

Thank You

[V-yubandi-msft]

Hi @smpa01 ,

We wanted to touch base as we haven't received a response from you yet. We hope the solution provided was useful. If you require further assistance or have any more questions, don't hesitate to reach out. Your feedback is invaluable, and we look forward to your response.

Thank You.

[V-yubandi-msft]

Hi @smpa01 ,

Thanks for reaching out to the Fabric community. Everything is being done correctly, but when using URL filtering, the table visualization updates correctly, while the slicer does not show the filtered value in its dropdown. This is because slicers do not dynamically pre-select the filtered value based on URL filtering.

To fix this, change the slicer style to Single Select.

• In the slicer settings, turn on Single Select.
• This will ensure that only one value is selectable in the slicer, and it will always reflect the filtered value when a user selects it or when URL filtering is applied.
• The dropdown slicer should automatically update to reflect the URL filter as it only allows one selection.

Did I answer your question, please mark it as the Accepted Solution, it will help others. If you need more details, feel free to reach out. Let me know if you need any further modifications.

[smpa01]

@V-yubandi-msft  I followed what you asked but it does not give me what I need

filter=tbl/region eq 'usa' and tbl/year eq 2024

The default filters with "Single Select" are region='uk' and year=2025.

I don't think URL query string parameters are able to overwrite the default filter values from query string parameter rather it creates the following

Please let me if there is still a workaround?

[V-yubandi-msft]

Hi @smpa01 ,

Thank you for your feedback. We have reproduced your scenario and identified the solution you need. Please refer to the attached snapshot for details. Take a look and let us know if it meets your expectations.

https://msit.powerbi.com/groups/625ab5fe-e2cc-419c-a893-7a071b55af4a/reports/54144716-854b-4492-b5d9... eq 'uk' and Table/year eq 2024

https://msit.powerbi.com/groups/625ab5fe-e2cc-419c-a893-7a071b55af4a/reports/54144716-854b-4492-b5d9...

https://msit.powerbi.com/groups/625ab5fe-e2cc-419c-a893-7a071b55af4a/reports/54144716-854b-4492-b5d9... eq 'usa' and Table/year eq 2025

Double check the following steps:

1. Table and column names in the URL are case-sensitive.
2. Ensure the names in the URL match exactly.
3. Ensure your dataset contains rows matching the filter.
4. Use a properly formatted and encoded URL.
5. Open the report in Power BI Desktop and apply the filter manually:
   • region = 'usa'
   • year = 2024
• Add filters for
• Confirm visuals update as expected.
6. Publish the report and test the URL filter again.

If you still face the issue, then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.

I'd also be grateful for a 'Kudos' if you found my response useful!