Forum Discussion
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
You may take a look at the link below.
https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/
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.
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&moderation-hash=fc2e62cd420bd892cbef9eb5c4e4eb99#comment-24033.
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?
