Who hates Power BI URL Parameters?

I love ’em, me, until I need to extract a custom URL – especially if it’s to this, this, this, and this – to share with others. With a bit of DAX and button trickery, however, there’s a way to add a button to a page so once values are selected in a slicer, the button is displayed – allowing us to save the URL to that filtered set… 🥳

Three simple steps to achieve this:

1. Add a measure concatenating the values in a slicer to your DAX query:

GenerateLink =
  VAR ConCat =
           VALUES ('Table'[RowID]),
           'Table'[RowID], ","
  VAR Link = 

2. Add measures to make the button’s text and icon black or red if any values are selected, and transparent if none are:

MakeTransparent =
MakeRed =

3. Finally, add a button, specifying a ‘Rule’ to use MakeTransparent and MakeRed values for the icon and text colour default/hover states, and the ‘Action’ to go to the webpage based on the ‘GenerateLink’ measure.

Discover more from Information Handyman

Subscribe to get the latest posts sent to your email.

Leave a ReplyCancel reply