Reputation: 11
I have a report in Power BI. Currently I can drill through from home page using Field A to multiple other pages (say page for Category 1, page for Category 2, page for Category 3, etc.).
Is there a way to use dynamic parameters in a URL to replicate the effect of Drill through functionality? (So that I can determine a specific value of Field A, using some calculation I have, and pass it through as a parameter)
When I checked, the URL for a Category X page didn't change based on the value of Field A I selected to Drill through.
Thanks!
Upvotes: 1
Views: 4464
Reputation: 40204
Yes. You can create dynamic text measures to use for URLs.
Here are a couple of more detailed resources:
https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/
https://www.cloudfronts.com/dynamic-url-filtering-power-bi/
Upvotes: 1