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 ChampionV-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?
Community SupportHi 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 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!
- 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