{"id":1065,"date":"2021-11-20T19:02:41","date_gmt":"2021-11-20T17:02:41","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1065"},"modified":"2021-11-20T19:02:41","modified_gmt":"2021-11-20T17:02:41","slug":"power-bi-page-navigation-using-a-slicer","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1065","title":{"rendered":"Power BI &#8211; Page Navigation using a Slicer"},"content":{"rendered":"\n<p>Many reports are having multiple pages and it is mostly a problem for the business user to navigate to the right page to get the right insights. If you have report with less than 5 pages, it is easy to create an overview page with different buttons for the navigation. But in the past, I\u2019ve seen and working with reports which includes more than 10 pages to provide insights for the different business cases. To maintain so many buttons, mostly you don\u2019t have enough space at the pages, and it is a problem to add the description for each. So, it is a good idea to use slicers for the navigation. How this can be done? See below &#x1f60a;<\/p>\n\n\n\n<p>First, I created the report with multiple pages including an overview page<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"568\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image.png\" alt=\"\" class=\"wp-image-1066\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-768x462.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-500x300.png 500w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>For the next step to create a meta data table, I\u2019ve added a table with the different page names and for each page a short description. With this information you can provide a page description for the user. This table must maintain if you add new pages.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"752\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1.png\" alt=\"\" class=\"wp-image-1067\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1-300x239.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1-768x611.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-1-377x300.png 377w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Next, I\u2019ve added a single value slicer with the page names and a card with the description for the selected page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"568\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2.png\" alt=\"\" class=\"wp-image-1068\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2-768x462.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-2-500x300.png 500w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Now, you need a button to create a page navigation to the selected page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"568\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3.png\" alt=\"\" class=\"wp-image-1069\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3-768x462.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-3-500x300.png 500w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To enable the page navigation, you need a simple DAX measure to gather the selected page from the slicer:<\/p>\n\n\n\n<p>Navigation = SELECTEDVALUE(&#8218;Table'[Page])<\/p>\n\n\n\n<p>Now, you can configure the action of the button by using the measure. And that\u2019s it, if you select a page from the slicer, you get some information and when you click to button, you navigate to the selected page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"568\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4.png\" alt=\"\" class=\"wp-image-1070\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4-768x462.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/11\/image-4-500x300.png 500w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Many reports are having multiple pages and it is mostly a problem for the business user to navigate to the right page to get the right insights. If you have report with less than 5 pages, it is easy to &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1065\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1065"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1065"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1065\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1065\/revisions\/1071"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}