Forum Discussion
Pass parameter value in URL query string?
- 4 years ago
Open the report and switch to the bookmark of choice and copy the URL
You could do the URL filters when using fields (not measures like you want to do).
But there are approaches to achieve the switching of displayed metric types.
It typically consists of a slicer (based on a disconnected table) and a "universal" measure that uses a SWITCH statement to decide which measures to display.
- Dave824 years agoFrequent Visitor
That is what I am doing already, I am using a global measure with a switch to do the current measure selection, the problem is I lack the knowledge of how/when to tell the report which measure to switch to when the report loads.
I am migrating a bunch of reports from Spotfire, and in Spotfire you could save bookmarks (which I know you can do in PBI as well) and then you could reference the url via the bookmark id like https://spotfire.mydomain.com/report/Papermaking?bookmarkid=someguid and it would load the specific view with all the settings saved. The goal here is the user can open the report and not have to do a bunch of manual filter selection (they need things made easy lol). I really don't want to have to make 100 separate pbix report files, I wanted it to be as dynamic as possible, since we will have like 20 different measures that hit the same data table.
I guess I naively assumed PBI was just as mature as Spotfire.