Hyperlink affected by filters

[Syndicate_Admin]

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

[MattiaFratello]

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?