Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
smpa01
Super User
Super User

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

 

 

 

smpa01_0-1736962870459.png

 

 

What I was hoping the URL filtering to return

smpa01_1-1736963020400.png

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

smpa01_2-1736963176955.png

 

thank you in advance.

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 ACCEPTED 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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

7 REPLIES 7
V-yubandi-msft
Community Support
Community Support

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.

V-yubandi-msft
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community Support

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 2024

 

 

 

smpa01_0-1737121694850.png

 

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

 

smpa01_1-1737121875707.png

 

Please let me if there is still a workaround?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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

Vyubandimsft_0-1738040490634.png

 

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

 

Vyubandimsft_1-1738040531973.png

 

 

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

 

Vyubandimsft_2-1738040531974.png

 

 

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!   

 

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.