Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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
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.
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 ,
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 ,
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.
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 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?
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... eq 'usa' and Table/year eq 2025
Double check the following steps:
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!
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
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
52 | |
45 | |
24 | |
24 | |
21 |