Forum Discussion
Impactful IndividualSlicer for report navigation
You can use the following approach for that.
-
Create a small table with report names and their report URLs (Sales, Marketing, etc.).
-
Use this table in a slicer.
-
Create a measure that returns the selected report’s URL.
-
Place a card or table visual with that URL and enable “Open URL on click”.
-
Super UserYes, 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.