Auto update URLs in my table by slicers

[wizarddata_]

Hello everyone,

I'm working on a report in Power BI where I have a table containing URLs. These URLs need to be updated automatically based on slicer selections, such as time periods and other subgroups. For example, when a user selects a different time period or subgroup using slicers, the URLs in the table should update accordingly.

Could someone please guide me on how to achieve this functionality? Any help or suggestions would be greatly appreciated. I would like for the url on the table to go to a landing page and have the same filters that were applied on power BI. 

[wizarddata_]

Hello what if the date ranges are not in the same format as power bi. Also what if the categories can be appended so for example landingpage&subgroup 1 & subgroup2.com if you select multiple filters.

[rajendraongole1]

Hi @wizarddata_ We update URLs in a Power BI report based on slicer selections, create dynamic URLs that incorporate the slicer selections with dax Selectedvalue() function.

Measure:

1.SelectedTimePeriod = SELECTEDVALUE('TimePeriod'[Period], "DefaultPeriod")

Subgroup:

2.SelectedSubgroup = SELECTEDVALUE('Subgroup'[Group], "DefaultGroup")

create a dynamic measure by using the above two seletedTimeperiod and selectedsubgroup

3.DynamicURL = "https://yourlandingpage.com?period=" & [SelectedTimePeriod] & "&group=" & [SelectedSubgroup]

Create and add the Dynamic URL to Your Table as below using calculated column

UpdatedURL = "https://yourlandingpage.com?period=" & [SelectedTimePeriod] & "&group=" & [SelectedSubgroup] & "&item=" & [ItemID]

for cross check create a table chart add the updatedURL column.

This approach allows the URLs in your table to update dynamically based on the slicer selections. Users can click the URLs, which will direct them to the landing page with the same filters applied

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!