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
rbartles111213's avatar
rbartles111213
Helper I
2 years ago

Anonymous man you have my head spinning in a good way 🙂 . Thinking of the measure, how can I get it to know for each button to get specific URL. 

 

Example - 

I added an ID column to the table. So IF the selected value is say ID = 1 then use the URL column for the button. 

 

If they choose ID = 4 next then that URL. 

 

If they then choose ID = 119 next then that URL assigned for the button and of course the Report Name column on the button so they know which is assigned to which button.

 

Then we have a dynamic bookmark button page. 🙂 

 

Thanks in adavance for any assist on this one! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rbartles111213 ,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • rbartles111213's avatar
      rbartles111213
      Helper I
      2 years ago

      Hello, sorry first time asking for help on here and my company doesn't allow us to add files externally so some dummy image is below. 

      Basically based on the selected values in a table, activate each button in the order they are in the filtered list. If not selected, don't activate the button. If the button is activated use the web url as the action. 

       

      Image is the idea but having 10 buttons and 4 would be active based on selected and 6 deactivated.

      • 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