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 = CALCULATE ( CONCATENATEX ( VALUES ('Table'[RowID]), 'Table'[RowID], "," ) ) VAR Link = "https://app.powerbi.com/groups/me/reports/[YourReportID]?chromeless=1&filter=Table%2FRowID%20in%20("&Concat&")" RETURN 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 = IF(ISFILTERED(Table[RowID]),"Black","#FFFFFF00") MakeRed = IF(ISFILTERED(Table[RowID]),"Red","#FFFFFF00")
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.