Forum Discussion
Slicer Filtering with URL query string parameter
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.
Thanks for looking into this and I did manage to solve the problem on my own through a series of trial and error.
What must not be done
a. No slicer shoule be made to Single select (for the reason explained above )
What needs to be done
Option 1 - create vertical list on the slicer settings (visual -> slicer settings-> options-> style) and don't select any values. When URL query string is supplied with a parameter, it will filter the data model correctly but the end user will see that particular slicer value (the one/s passed on to URL query string) slicer value as unselected (as visible here ) in the slicer viz.
Option 2 - create vertical list on the slicers (visual -> slicer settings-> options-> style) and select all values. When URL query string is supplied with a parameter, it will filter the data model correctly and the end user will see that particular slicer value (the one/s passed on to URL query string) as selected in the slicer viz
7 Replies
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.
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 2024The 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?
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-ea935c883d55/91389c7f170b7e649774?filter=Table/region eq 'uk' and Table/year eq 2024
https://msit.powerbi.com/groups/625ab5fe-e2cc-419c-a893-7a071b55af4a/reports/54144716-854b-4492-b5d9-ea935c883d55/91389c7f170b7e649774?filter=Table/region eq 'usa' and Table/year eq 2025
Double check the following steps:
- Table and column names in the URL are case-sensitive.
- Ensure the names in the URL match exactly.
- Ensure your dataset contains rows matching the filter.
- Use a properly formatted and encoded URL.
- Open the report in Power BI Desktop and apply the filter manually:
- region = 'usa'
- year = 2024
- Add filters for
- Confirm visuals update as expected.
- 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 LearnIf 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!
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.
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
Hi smpa01 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you or let us know if you need any further assistance?
Your feedback is important to us, Looking forward to your response.
Thank You.
