Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

Hyperlink affected by filters

Hello.

I am inserting PBI analysis in the company's CRM (Dynamics 365 Sales), and I am asked to be able to navigate from these analyses inserted in detail in the CRM. I have inserted a hyperlink for example to the list of offers, but I can't find that if the analysis has a date filter the list that opens the hyperlink is affected by the filter, do you know if this is possible and if it were the case how to do it?

Everything I find helps, for example, to insert hyperlinks in tables to see specific offers, but it is not what we would be looking for.

Thanks a lot

1 Reply

  • MattiaFratello's avatar
    MattiaFratello
    Icon for Super User rankSuper User
    1 year ago

    You saying the DAX Measure
    SelectedURL =
    VAR SelectedValue = SELECTEDVALUE('YourTable'[YourSlicerColumn])
    RETURN
    LOOKUPVALUE('YourURLTable'[URL], 'YourURLTable'[YourSlicerColumn], SelectedValue)

    won't work for your case?

     

    1. Card

    • Add a Card or Table visual and use the measure as a field.
    • Set the field to "Web URL" format (Modeling > Data Category > Web URL).

    2. Buttons

    If you want a slicer to control navigation, you can:

    • Create a button in Power BI.
    • Use the button's Action property and set it to "Web URL."
    • Use the SelectedURL measure as the destination URL.

    Alternatively, have you looked into Power Apps?