Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop

Tired of having a ton of buttons to accommodate page navigation within your Power BI report? Conditional navigation is an INSANE AMAZING way to reduce visuals on the report and provide a clean way to navigate your report.
⬇ Download sample: guyinacu.be/cn...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #2M2 #GuyInACube

[@rosselliot2264]

4:15 - if you hold alt when moving objects, it allows you move them unsnapped to grid. This is the same for all office applications, apart from excel where it does the opposite and makes object snap to the cell grids.

[@GuyInACube]

Nice! Thanks for the tip 👊

[@michaelrichards2050]

It's a year later but if you're having a bad day I learned about the alt button through this and it saved me so much time :D

[@StaticCrowbar]

@@michaelrichards2050 It is now 2 years later and I have just learned this Alt trick because of this comment...

[@Desperatemeasuress]

It is now 3 years later and I only just learned this thanks to this comment 🥲

[@lakeoffm]

Actually, if you keep the slicers synced, you’ll get your navigation field to display the current page as well :) A bit of additional functionality here)

[@Xilver_]

Was wondering what it would do. Thanks

[@bepokerst]

Was thinking the same thing. We should actually sync it to avoid the page and slicer showing two different names.

[@katharinecooney8570]

Thanks - I was finding that annoying

[@ngehpeace6772]

Thank you for I couldn't navigate some pages.

[@FoodPandaEatBite]

While navigating to select the field value in conditional formatting - it seems it's greyed out. I am unable to select the required based on field value

[@ianclarke1314]

That is brilliant! I’ve got a report which has quite a few tabs and for someone to go to the right one takes ages!! You are a genius!

[@Binayprabhu]

Hi, I have tried this But i am unable to select Based on Field value for conditional Page Navigation. I have Given correct names of Pages too in the Table . Can you please help here.

[@hi_vishy]

They should provide the same conditional formatting for bookmarks as well.

[@jamezday]

Yoooooo! This one was a page turner!

[@GuyInACube]

hahahahaha indeed 🤣

[@panick_]

This is bananas indeed! I've used it in combination with RLS to allow different roles to view different report pages when they click a button on a summary chart. Made my life so much easier!

[@RalphieVII]

I'd like to see you get into the next step of this... Add a couple true/false columns to your Navigation table that set if the page should be visible to certain groups(Seller/Manager etc) Then you can have a row of buttons with dynamic text and dynamic action. Finally you add that column to your RLS and you can have different nav buttons for different roles. I'm struggling with implementing this where it changes the fill for the current page and also hiding the empty button if the role has fewer pages.

[@analistax]

Great!!! I would love to do something like this, but choosing the bookmark.

[@deanj5961]

Me too!

[@Eldritch_Vines]

As a data scientist that loves GameCube and Marvel... I'm a big fan of your guys' work! Very much appreciated!

[@haroon420]

Thanks buddy. This will be handy but I’d like you to show us one step further. Basically, id like to hide the pages(reports/tabs) that I don’t want to see. So from a home screen, id like to click on say France and France tab suddenly appears. This is possible in excel but I haven’t yet found it in pbi. So my pbi report looks so much more busy with dozens of tabs whereas on excel they could be hidden with a macro in the button. Can you show us please? I haven’t seen anybody investigate this issue before. But I’m sure the ppl would love it!

[@edgards]

Omg this is so useful! Especially for those challenging users who never seem to find anything when it's right in front of them.

[@jamezday]

That's my whole userbase right there 😭

[@vikrenth]

Wonderful, this can help bridge the gap for tab wise RLS which is not available in Power BI, we can apply RLS based on Navigation & Hide rest of the pages - we should be done, right?

[@AlexDupler]

Navigation is not a security feature. You can bypass it in a number of ways (manually editing the URL, analyze in excel are two that come to mind.)

[@MrNH1]

Love it! This will allow me to make navigation completely table driven, combine it with RLS and some measures... I can now remove navigation items that relate to pages without info (because RLS will not allow the data to show to some folks).

[@GuyInACube]

100% agree with Alex! While you could use this to further control page navigation and hide pages by default, it should not be looked at as a security feature for page navigation. The pages can still technically be accessed if you know what you are doing. This is more obfuscation as opposed to security.

[@Baldur1005]

5:36 - That was what I was waiting for ;)

[@GuyInACube]

hahahaha It's BANANAS!

[@nathangrant104]

Ideally, it would be nice to do this without a button for GO so that the command to navigate to the page executes upon release of the mouse button from selecting the appropriate page. Not yet sure how to do that, but I am learning.

[@abbabccbcddc]

not sure if you figured out how to do this, but if you did please post here! i used a workaround by using a horizontal slicer and putting a blank box on top of the slicer value with conditional navigation so you dont need the extra go button

[@dileepmungara6127]

This is so useful to navigate to other pages..than button option. Thanks mate .

[@GuyInACube]

Agreed! 👊

[@prashantdeshmukh11]

You are a legend Patrik ... such a simple way to navigate between the pages .. too good mate, thanks a ton !!!

[@michaelnoonan1833]

Better to not need the GO button and the drop-down selection changes pages, like a horizontal slicer.

[@kishoreyc]

wow. just in time. just in time. Revamped my Page Nav page in my report before publishing it. now it looks super cool. thank you Patrick.

[@nassaugustavo]

Is there a way to navigate without clicking on "Go" button? Like just selecting from the list?

[@gracemageau9989]

I followed this video, but the action of the Page button does not take the page name as a field. Why? I've resolved it by using a measure but still want to know the reason. Thanks a lot!

[@meriemarfaoui3492]

Thank you Patrick for the video ! But I was actually thinking that the tabs for each country contain the same information and in the case where we can have a huge number of countries. Is it possible to just build one tab and dynamically change the information in that tab according to the country selected on the main page ?

[@shubhamtiwari5653]

Hi, Did you get any solution for this kind of situation ?

[@kristinsauerhoff6398]

Love your videos ... so helpful! I created page navigation using this video and it worked great! I must have changed something, because now the "Go" button will only navigate to the second selection in the slicer! Ugh! I checked all of my page names to ensure they are identical, and they are. i should also note that I actually have three slicers because I have three sections of my report, each with multiple pages. one of the three works perfectly. the other two show this problem of only navigating to one of the pages. Thoughts? Thanks, in advance!

[@CBDTalkPodcast]

PERFECT TIMING! This is a huge help on a project that I'm working on! Thanks!

[@GuyInACube]

Awesome! Glad it was helpful 👊

[@adolfoalejandroa]

@@GuyInACube I cant select the field on "based on field" in my FX option, you now why?

[@adolfoalejandroa]

I cant select the field on "based on field" in my FX option, you now why?

[@spreadsheetsplays871]

Hey Patrick, thanks for the video. If you have New Look turned on in Power BI Service, won't the user get a list of pages to jump between on the side? I can see this being useful if you turned page navigation off at the Power BI Service level. Why even come up with New Look then if people are going to work around it. Cool button btw. It'd be 1% cooler if on country selection from the drop down it just jumped you to the page. Thanks again for all your awesome tip and videos!

[@derekgarner8524]

I've not seen page level governance as an option yet, though I'm very new to Power BI, but I've been able to use this navigation method on a 'Page' table linked to 'Roles' table (for RLS) - Hide all the pages except for this Navigation page, and it looks very promising as the method navigates to the hidden page nicely. Only the pages permitted to that role appear in the drop down list preventing access to unwanted pages. I expect I'll need to remove any Report Level bookmarks as well but that is ok for me, users will be able to create their own.

[@baluragoonathan3666]

Awesome Patrick. Now we don't have to use Bookmarks and also repeatedly adding multiple buttons for each page to Navigate. Just a button and Drop Down List would take us to the page we want to navigate. We just have to add the entry for the new page in the navigate table every time we add a page in the report. Thank you for sharing this feature.

[@rbjusmc1]

Many thanks! I can't show you what I'm working on because it's high-speed, low-drag stuff but you saved me so much time! Keep up the outstanding work! Very simple and clean.

[@GuyInACube]

Glad it helped!

[@sofiiakolomieiets2490]

I'd say it's less user friendly, as it requires more clicks from the end user of the report 🤔 but perhaps it could be useful for reports with many pages

[@sandeepreddy7687]

Thanks Patrick. You always blow everyone with new tricks. Loved it!

[@amitshukla189]

Patrick.. your tips always reduce our work efforts. Thanks Man !!!!!

[@EllovdGriek]

Nice feature, makes it more easy to add navigation and therefore an interactive report. Is this coming available for bookmarks as well?

[@RonaldPostelmans]

Hi Patrick, Nice video, i like knowing how to do this, it is a nice feautre. I don't know if this is being used in my company. They also have the tabs.Which i can hide but i think you still see the tab bar. Extra buttons for navigation look grate but i think we mostly choose to have as much space possible for the visuals it self. So every slider with a go button can be replaced on the canvas by an actual number which has value to the users. most of the times they want so see as much numbers as possible on 1 page, so every extra button which is not actually necessary can be an overkill.

[@abhisoulstormer]

signature of a powerBI video addict - 6 mins pass "wait the 2 mins are over!" :'D

[@GuyInACube]

LOL yeah... was a bit past 2 minutes... Hopefully it was worth it though.

[@dzulfadhli87]

Awesome Partrick! just wondering if we can remove the "go" button and rely only on the slicer button to navigate through, so that we can navigate using 1 click instead of 2 click in this slicer.. if this can be done ..its BANANAS

[@zekaroz]

It would be really nice to be able to create partial reusable components that we could reuse in multiple pages to create stuff as menus and such stuff in a modern way! Great info though!

[@MatthewJQuintero]

Thank you for all of your videos. How do I automatically hide the Pages Pane on a report? I have created navigational buttons on the actual report so I really don't need the page tabs on the left. Thank you again for all of your videos!

[@AdamPopeLibrarian]

add ?chromeless=true as a suffix to your report URL, will push the left navigation to the footer and make your report much cleaner

[@mazevedopro]

Brazil here!✋

[@GuyInACube]

Hello Brazil! 👊

[@prabhatn]

Nice one. Thank you. When we have many pages with the same view (having a Table visual with different filters applied), so, Is that possible to have just one page with multiple bookmarks, and on button click we navigate to the page with some Bookmark?

[@4karankhanna]

This is really helpful Pat. Thank you so much. How did you make images blow out of page like a 3D

[@bladerunnerisback]

Just enable Shadow on the visual

[@jennyesquibel2050]

Is there a way to insert a button/bookmart/etc. into a page that opens a different Dashboard instead of the dashboard you are in?

[@tomaszledzki7747]

That looks great. A question I've got though is, is it possible to do the same thing but with bookmarks? I'd like to keep only 1 page and create bookmarks with different fiters applied. In the case you presented it would be 1 page where bookmarks would be filtered by country (filter applied on page level). Bookmark 1 being UK, 2 Germany and 3 France. Then I'd like to add the slicer allowing me to navigate through these bookmarks. btw, one of the best channels when it comes to learning Power BI. Many thanks

[@ScottPerley]

Awesome! I actually started to get excited when you showed that it would just use the table!

[@ravikumarbva5544]

@Guy in a Cube, Thanks for this post. Can we skip the button and navigate using slicer only?

[@Madhu-Muvattupuzha]

Thanks Patrick .. I used this stuff today after viewing your video

[@AshutoshDeshpandeOfficial]

Navigation has always been a major problem for me in the power bi reports. Previously If I wanted to navigate to 10 pages from each of them, 10 buttons were required. In Tableau we can simply use a combination of parameters and a dummy filter, to show our hide visuals (sheets). Thanks Patrick, for introducing to this method.😊 Although, it still resolves the need to create 10 buttons and replaces it by just a slicer, is there a way I could avoid Go button actions and change the page instantly upon changing the selection? Because, this might confuse the client... And he will come back to me asking Why the fridge is it not changing?

[@GuyInACube]

Unfortunately no. You need something to trigger the action. A slicer alone can't do that. Has to be a button/image or something of the like.

[@santoshraghunath8133]

Hey, this is awesome. I have a small doubt. Is there a way to not show the name of the current page we are in??

[@christinastorie3100]

This is a great and thank you for sharing. Is there a video that helps create a visual table of contents? Like if I have 15 different reports in on workbook and I want one "page" to be the front page and provide a brief description and a link to allow an end user to select that report, and then return to TOC and select another based off their needs...

[@arameshkumar5072]

🙏 ❤️ From India , Thanks to sharing your knowledge Patrik ❄️❄️

[@brettbillbe1141]

Are there limitations for this in datasets with calculation groups? I'm not getting a summarization option, nor am I able to select the page name field (or any other field in the entire dataset, measure or column), and that's the only thing I can think of that could be causing this issue.

[@melwood5517]

I had the same issue. I had to create a measure using SWITCH to get around this issue and it works.

[@bladerunnerisback]

Excellent. Very useful specially when you have 10+ pages on your report. Thank you!

[@deevakerg]

can we create a conditional home page without using a button?

[@_Areknames_]

Great video, is there a way to use a tile's name as a textual link to page ( just as it if was a button) but as an hiperlink in each row of a table? thank you if you can respond

[@amorosperkingstchinda1086]

Hey Patrick, how are you doing man? I've been watching your tutorials for a while now, and many thanks bro. I have a little question: is it possible to navigate through 2 differents power bi reports with a button for example? It will be extremely beneficial to me; I've been looking for a way to accomplish this but have yet to find one; what do you think?

[@user-fk7ue7fu7h]

Does this slicer conditional navigation approach work for navigating between bookmarks too? I would love to make bookmarks selectable from a drop-down, instead of buttons.

[@ketanpatil3489]

thanks Patrick for 2 min Tuesday video... this is really nice.

[@GuyInACube]

Most welcome Ketan! 👊

[@bluesage1528]

Great! Thank you. Will definitely use this technique

[@ahmadaltayeb1983]

Thanks Sir, but if I need to move from page to another one, without using Ctrl key, I can do that or not, please advise, thanks.

[@JoelShafron]

Patrick, When I follow these steps all my fields are "greyed out" and I cannot select anything for Based on Field.

[@toirshad]

Yes, for me also it's not able to select anything from 'Based on field'

[@Sameer-it2qu]

Very helpful , keep the good work going on

[@Adin7785]

Love it!! Great feature, thank you for sharing.

[@GuyInACube]

Most welcome! Thanks for watching 👊

[@datagy]

Awesome tip! Thanks for sharing! I hope this gets developed further allow for nested lists, etc.

[@thealchemist6133]

Always learn something new every time watch your channel :)...Keep it up !!

[@maxzr]

Got it & loved it! Thanks

[@riverland0072]

Thank you so much for sharing this. When I tried it, I did not see any 'fx' symbol next to the destination. Please do you know why I am having this problem?

[@MatheusMarchezi]

the conditional formatting for page navigation was removed with the new format pane. You have to disable the new pane, and use the old one, to use this funcionality. However, after editing the conditional formatting, you can change the pane to the new version again

[@jperezts]

@@MatheusMarchezi How can I disable the new pane?

[@riverland0072]

@@jperezts go to settings and to then preview features. you will see "New Format pane" as one of the options, uncheck that

[@jperezts]

@@riverland0072 Thank you very much!👌👌👌👌

[@jpb2085]

Very nice, wish there was a standard viz for this drop down naviagtion so number of clicks for user could be reduced by getting rid of the "go" button

[@Bharath_PBI]

Yoooo, This is really being efficient, not lazy.. 😊 At some point I thought you would use a selected value DAX function but much better.!! Keep it up 👍

[@GuyInACube]

hahaha nice 👊

[@adolfoalejandroa]

I cant select the field on "based on field" in my FX option, you now why?

[@wmgemmell2833]

Love it! Another amazing video. Keep up the great work, All!

[@GuyInACube]

Appreciate that! Thanks for watching 👊

[@PSModelling]

Is there a way to automatically index the tab names, would be much better than manually entering them each time as the names can change or new tabs are added.

[@rkaiwayoflife]

Good way to navigate.thanks for sharing

[@ingorost9717]

It was so very very great what you Show, but i need a navigation from file a.pbix Tab1 to b.pbix Tab2 where can i create a link to a other file and open the spezial Tab, best way with a seperate Filter in that Tab !!! Do you have an IDEA

[@amitsolanki9825]

This is excatly what l was looking for......I think it can be also done with bookmarks.....

[@leyshonrr]

Well this is a game changer for bulky reports.

[@andre-analytics]

It's very useful thanks a lot

[@jbuford04]

Love it, wish there was a way to trigger the navigation without an additional user 'click'

[@GuyInACube]

Agreed. We need something to trigger the action though. Slicers don't do it on their own.

[@heatherr5191]

perhaps at some point we can get an "activate" toggle on the page slicers (similar to the one now available for filter pane) - if you have that turned on, it won't immediately take action, but if you turn it on, it will so you don't have to click a button.

[@PHOBIAx57x]

Should be able to do this but with slicers controlling the drill through. That way you could mimic like a home page UI where users can set all their filters with the slicers then drill through to the visuals. Like a most web pages are designed.

[@MySpreadsheetLab]

Perfectly explained! Thanks Patrick!

[@sumitarora1618]

how to hide the other 2 pages. I mean, when user select Germany from the drop down, is it possible to just show that page and hide the other two (UK, France). Thanks!!

[@evan6547]

I’m assuming this isn’t possible when you have a live connection to a dataset which is a tabular cube?

[@shanmukhasrinivas9473]

Loved it.....Thank you So much Guy in a Cube

[@red2fourty650]

Great video, you guys in a cube explain thing easily. Great content

[@photoo848]

How does this save clicks? Using the tabs is one click, using the dropdown + GO-button is two clicks

[@harshjoshi3210]

Hello Patrick, I actually want to know how you add different countries maps and they change accordingly when a particular country is selected. If there's a video which you might have created please guide me towards that video. Any help in this aspect would be really appreciated. Thanks and Warm Regards, Harsh

[@amitmend]

Will this work with DirectQuery (and not scheduled refresh)? Seems like the column is grayed out and the action can't be set

[@faridhadjali7294]

Nice One !! shame does'nt work in live cube connection !! can't add any data in Power BI ! any tips ??

[@Tipejote]

Is there a way to make the slicer directly do the navigation? Without a button.

[@manoj4859]

Hey Patrick - do you know oif PBI desktop allows connecting to a PBI dataset in the recent version?

[@_Areknames_]

Great job as allways , Question: is there any way to make this work in a dashboad too?

[@krupakshitij7286]

Wow! Very helpful. Thank you

[@annacorr2263]

My team are going to love this!

[@divishajoe1508]

How do you sort the column by order rather than by Alphabetical(other than using 01, 02 etc? Thanks

[@julaulardy251]

Great feature indeed. I wanted to use it in order to reach hidden pages so that I could have kind of "admin pages" that could be seen only by few people using USERPRINCIPALNAME. But since PDF export can also export hidden pages, the purpose has a flaw. Any idea so that certain group of user don't have access to hidden pages ?

[@kiranl1980]

when i published this report in to service and pin to dashboard does it work or only it will support in reports ...?

[@alicedwonderland7733]

This is amazing stuff! It saves up so much space!

[@nicknovy550]

Could you use a bookmark to toggle different navigation datasets (i.e. short report version vs long)?

[@constmcdt]

This is so awesome - thank you!!!

[@ashishmakwana7426]

Patrick, First of all thanks for such amazing videos. I would like to set the same page navigation link in table visual. I have many columns and want to use few from them to navigate on another page. need to set link on column data and want to redirect on another page of same report. Is there any way to do so? Thanks in advance.

[@shoogan]

Fantastic video. Thanks for sharing

[@poojitha4523]

I have created detailed page for example page1,page2,page3... and created bookmarks , also I have summary page where I kept all these pages in tabular model if I click on page1 in summary it has to redirect to the page1 detailed page. Is there anyway that I can redirect not by using icons or buttons or images.