Slicer for report navigation

[powerbiexpert22]

can it be possible in power bi to navigate to already existing different reports ( not page) based on slicer's value

example let say i have slicer to choose between existing sales report and marketing report, if user select on sales report value in slicer then it should navigate to sales report

[v-karpurapud]

Hi @powerbiexpert22 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[Poojara_D12]

Hi @powerbiexpert22 

Yes, it’s possible to navigate between different existing reports in Power BI based on a slicer selection, but not directly in the way slicers normally work. Power BI slicers don’t have a built-in “action” property to trigger navigation to another report. However, you can achieve this behavior using a combination of DAX measures, card or button visuals, and conditional navigation URLs. The typical approach is to create a table containing the names of the reports (e.g., “Sales Report”, “Marketing Report”) and use that table as the slicer’s data source. Then, create a DAX measure that returns a different URL based on the slicer selection — for example, returning the published URL of the Sales report when “Sales Report” is selected, and the Marketing report URL otherwise. You can then use a button or shape visual and turn on Action → Web URL (or Action → Bookmark for internal navigation) with a conditional formatting rule tied to that DAX measure. When users select a slicer value, the button dynamically updates its link, so clicking it opens the relevant report.

An alternative is to use a navigation page with buttons that are conditionally shown using the slicer value (through the “Enable” property or layering with bookmarks), but this involves more manual setup. Direct, slicer-triggered automatic navigation isn’t supported, so the user must click a button or card after selecting a slicer value. This design pattern is common when creating “report hubs” or dashboards that act as a central navigation point to multiple published reports.

[v-karpurapud]

Hi @powerbiexpert22 

Thank you for reaching out to the Microsoft Fabric Community Forum.

Power BI does not have a built-in feature for slicers to directly navigate to external reports. However, you can achieve this by combining DAX measures with navigation elements like buttons or by using Power BI Service report URLs, as @mh2587  mentioned. One method involves creating a mapping table with report names and URLs, letting users select a report with a slicer, and capturing the URL with a DAX measure. You can then either show the URL in a Table visual, or create a button that uses the measure as its Web URL action for a more user-friendly experience.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.

 

[mh2587 · Accepted solution]

You can use the following approach for that.

1. Create a small table with report names and their report URLs (Sales, Marketing, etc.).

2. Use this table in a slicer.

3. Create a measure that returns the selected report’s URL.

4. Place a card or table visual with that URL and enable “Open URL on click”.