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 ,

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

    • 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!