Forum Discussion

rbartles111213's avatar
rbartles111213
Helper I
2 years ago

Dynamic Hyperlink Buttons Based on Selection

Hello Team,  I am looking for some creative advice!  Concept -  I created a master spreadsheet that is on SharePoint that I added all of our report direct links to each report and names, etc to so...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI rbartles111213,

Current power bi seems not include featured to auto create multiple buttons based on filtered table records.
BTW, here is the dax measure expressions that can show dynamic string and url based on selections.

DynamicName =
CONCATENATEX ( ALLSELECTED ( Table1 ), [ReportName], "," )

ConditionURL =
IF (
    ISFILTERED ( Table1[Report Selection] ),
    SELECTEDVALUE ( Table1[Report Link] )
)

Regards,

Xiaoxin Sheng

rbartles111213's avatar
rbartles111213
Helper I
2 years ago

Xiaoxin Sheng, thank you so much! The measures gave me the exact thing I needed for button text and URL!

I just need to work the logic of 1st selected to assign to the 1st button and 2nd to the 2nd button etc. Then I can create 10 buttons as default. Thinking out how that will work... 

Thank you again!