Forum Discussion
Power BI slicers
Hello Team,
There are two pages in a report and i want to get each of them by using a sclier.
Means At the first there's page-1 report then there's a slicer with value :- page-1 and page-2
When I click on page-2 it should redirect to page-2
Is it possible in any cases
Please Let me know
Thank you.
Hi BIswajit_Das ,
You can do this by using dynamic page navigation as this was not possible with just slicer only and it requires another trigger button to perform the navigation.
You can follow this blog where there is step by step instruction to create a dynamic page navigation:-
https://medium.com/analytics-vidhya/dynamic-page-navigation-in-power-bi-desktop-e97b9a11fd05
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
4 Replies
- pratyashasamal
Memorable Member
Hi BIswajit_Das ,
You can do this by using dynamic page navigation as this was not possible with just slicer only and it requires another trigger button to perform the navigation.
You can follow this blog where there is step by step instruction to create a dynamic page navigation:-
https://medium.com/analytics-vidhya/dynamic-page-navigation-in-power-bi-desktop-e97b9a11fd05
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C - BIswajit_Das
Impactful Individual
But I thought there might be a way to use slicer.
Thank you for responding.
- pratyashasamal
Memorable Member
Yes you are using slicers here .
But first you need to add data table with all the Page Names for example "Page 1 " , Page 2" ,etc.Step 1: Create the support table
Add a simple table in the data model, with no relationship with any other tables. It should contain
· an index column (for sorting),
· and the name of pages (to be used in the slicer)
We can use the Enter Data option for adding a table:
Step 2: Add the slicer
Add the slicer with Page field from the table created above
Include the following steps:
· Convert the slicer as a drop-down list
· Format > Selection Controls > Single Selection > On
We can use the index column to custom sort the table field as per the pre-defined page order
Select the column > Column Tools > Sort by Column > Select the Index column
Step 3: Add a button
Insert > Buttons
Alternatively, we could use any shape or image as well.
Step 4: Configuring the button
Select the button > Action > Under Type select Page Navigation
In Destination, click on the fx symbol to open the Destination setting option. For Based on field, select the field for the page from the table created in Step 1
Click Ok.
And that is it!
In Power BI Desktop, you need to use the CTRL key for the navigation to work.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
- BIswajit_Das
Impactful Individual
Although this is not what i need but the blog you share is quiet helpfully.
Thanks for responding.