Forum Discussion
Syndicate_Admin
Administrator
AdministratorHyperlink 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...
MattiaFratello
Super User
Super UserYou 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?