Forum Discussion
Community ChampionSlicer Filtering with URL query string parameter
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
Community SupportHi 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.
smpa01V-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?
- 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-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!
- smpa01
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