Forum Discussion
Dynamic URL button with multiple values from filtered table column appended.
I need to create a button who's URL is dynamic based upon the current values displayed in a table. The table values are dictated by a slicer.
For example, the URL should have a static prefix of "https://example.com/ASSET?", and the values produced from the slicer should be appended to the end.
ie. I use the slicer to filter the table. The table now shows the values "2344", "66668", "9836" in the first column. The URL should now be "https://example.com/ASSET?2344,6668,9836".
If I use the slicer to alter the values in the table, the URL should update to contain the new values instead.
Is this possible?
3 Replies
gibberish You could create a measure like this:
Measure = "https://example.com/ASSET?" & CONCATENATEX( 'Table', [Value], "," )You can then apply this measure using the fX icon:
Hi Greg,
Thanks for the fast reply. I did try this previously based on some advice from elsewhere, but the URL it creates contains every value in the source table, not just the values showing on the page based on the current state of the slicer.
For example, I use the slicer and the table only shows 3 values now, but when I click the button it opens a URL with hundreds of values appended.
I know why this is. It's because there are already other filters affecting the table visual before the slicer is applied. It is correctly applying the slicer to the result, but it is ignoring the filters that were already applied to the visual before the slicer.
Is there a way around this?
