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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JM_nxgn
Helper I
Helper I

Dynamic URL based on selected filters

Hi all,

 

I have two reports which each contain a fact table and multiple dimension tables. Both reports are filtered by similar columns. 

 

I'm trying to create a dynamic URL which links one report to another. Basically if I open report #1 and filter by date and client, I'd like to create a URL within report #1 which will take me to report #2 and have the selected filters persist.

I am publishing both reports so I can use the URL's of each report. Just not sure how to append the details accordingly at the end of the URL.

 

Thanks in advance!

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@JM_nxgn 

 

You may take a look at the link below.

https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-chuncz-msft 

 

Okay just a quick update. The link you sent is actually quite useful thanks. 

I have been using that in conjunction with https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/?unapproved=24033&moderatio....

 

So if you look at that link, the person uses a/a=1 as the first filter, this is to allow other filters to append upon the query string. I'm not sure why, but on my side, everytime i have the a/a=1 in front, the whole query string bombs out.

I have added a table called 'a' and a column called 'a' with a single value '1' in it. Not sure if I'm missing something. Any ideas?

@v-chuncz-msft 

 

Thanks for the link. I understand how they want to build the filter using query string parameters. I followed the method of making a dynamic one. I'm not sure if there's change in syntax, but in the link you send they use 'in' instead of 'eq'? It seems like 'in' allows for multiple filters within the same column whereas 'eq' only works for single parameters. 

It isn't working on my side when I use 'in' and when I substitute it for 'eq' I'm not sure how to make it so it allows for filtering on multiple parameters within a single column.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors