Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

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

  • 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's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual

    But I thought there might be a way to use slicer.

    Thank you for responding.

    • pratyashasamal's avatar
      pratyashasamal
      Icon for Memorable Member rankMemorable 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's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual

    Although this is not what i need but the blog you share is quiet helpfully.
    Thanks for responding.