Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop
Вставка
- Опубліковано 3 жов 2024
- 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
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!
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.
Nice! Thanks for the tip 👊
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
@@michaelrichards2050 It is now 2 years later and I have just learned this Alt trick because of this comment...
It is now 3 years later and I only just learned this thanks to this comment 🥲
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!
As a data scientist that loves GameCube and Marvel... I'm a big fan of your guys' work! Very much appreciated!
You are a legend Patrik ... such a simple way to navigate between the pages .. too good mate, thanks a ton !!!
Omg this is so useful! Especially for those challenging users who never seem to find anything when it's right in front of them.
That's my whole userbase right there 😭
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)
Was wondering what it would do. Thanks
Was thinking the same thing. We should actually sync it to avoid the page and slicer showing two different names.
Thanks - I was finding that annoying
Thank you for I couldn't navigate some pages.
Yoooooo! This one was a page turner!
hahahahaha indeed 🤣
This is so useful to navigate to other pages..than button option. Thanks mate .
Agreed! 👊
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.
Great!!! I would love to do something like this, but choosing the bookmark.
Me too!
They should provide the same conditional formatting for bookmarks as well.
PERFECT TIMING! This is a huge help on a project that I'm working on! Thanks!
Awesome! Glad it was helpful 👊
@@GuyInACube I cant select the field on "based on field" in my FX option, you now why?
I cant select the field on "based on field" in my FX option, you now why?
Thanks Patrick. You always blow everyone with new tricks. Loved it!
5:36 - That was what I was waiting for ;)
hahahaha It's BANANAS!
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.
Patrick.. your tips always reduce our work efforts.
Thanks Man !!!!!
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.
Glad it helped!
Awesome! I actually started to get excited when you showed that it would just use the table!
thanks Patrick for 2 min Tuesday video... this is really nice.
Most welcome Ketan! 👊
🙏 ❤️ From India , Thanks to sharing your knowledge Patrik ❄️❄️
Excellent. Very useful specially when you have 10+ pages on your report. Thank you!
Thanks Patrick .. I used this stuff today after viewing your video
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.
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
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.
Very helpful , keep the good work going on
Always learn something new every time watch your channel :)...Keep it up !!
Got it & loved it! Thanks
Great! Thank you. Will definitely use this technique
Love it!! Great feature, thank you for sharing.
Most welcome! Thanks for watching 👊
Awesome tip! Thanks for sharing! I hope this gets developed further allow for nested lists, etc.
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 👍
hahaha nice 👊
I cant select the field on "based on field" in my FX option, you now why?
Love it! Another amazing video. Keep up the great work, All!
Appreciate that! Thanks for watching 👊
My team are going to love this!
Great video, you guys in a cube explain thing easily. Great content
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!
It's very useful thanks a lot
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!
Good way to navigate.thanks for sharing
Perfectly explained! Thanks Patrick!
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.
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
Loved it.....Thank you So much Guy in a Cube
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.
This is amazing stuff! It saves up so much space!
Brazil here!✋
Hello Brazil! 👊
signature of a powerBI video addict - 6 mins pass "wait the 2 mins are over!" :'D
LOL yeah... was a bit past 2 minutes... Hopefully it was worth it though.
This is so awesome - thank you!!!
This is very cool and smart! Less clicks, the better!
Wow! Very helpful. Thank you
Great work patrick, gonna implement in my latest report 😎
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!
Nice trick there, saves a lot
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!
Nice feature, makes it more easy to add navigation and therefore an interactive report.
Is this coming available for bookmarks as well?
Great technique!!
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.
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!
Awesome! Thanks.
Fantastic video. Thanks for sharing
Loved it. Thanks Patrick.
Very great
This is excatly what l was looking for......I think it can be also done with bookmarks.....
I totally love it!
Great tip! Thank you so much!
Is there a way to navigate without clicking on "Go" button? Like just selecting from the list?
Well this is a game changer for bulky reports.
Better to not need the GO button and the drop-down selection changes pages, like a horizontal slicer.
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
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!
add ?chromeless=true as a suffix to your report URL, will push the left navigation to the footer and make your report much cleaner
Amazing, exactly what I needed!!!
B A N A N A S !!! awesome... will try this today.
Mind blown!!! That is awesome!!!
VERY helpful, thank you
Glad you liked it Justin! Thanks for watching 👊
Thanks, that's a very usefull video
Absolutely Brilliant!
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??
Awesome. Clicks are good👍🏻
Appreciate that! Thanks for watching 👊
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
Awesome Patrick!
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 ?
Hi, Did you get any solution for this kind of situation ?
This is B A N A N A S!
Thanks Patrick🙌😉
this is amazing!!
Very helpful, thanks man 👏🏼👏🏼
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?
Great tip
Excellent !
can we create a conditional home page without using a button?
You're awesome, man!
This is really helpful Pat. Thank you so much. How did you make images blow out of page like a 3D
Just enable Shadow on the visual
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?
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.)
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).
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.
Love it, wish there was a way to trigger the navigation without an additional user 'click'
Agreed. We need something to trigger the action though. Slicers don't do it on their own.
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.
@Guy in a Cube, Thanks for this post.
Can we skip the button and navigate using slicer only?
Great feature , I like it
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
its so fantastic, watsup my friend. i from Brazil tanks so much
Very nice! 👏👏
million thanks....
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?
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.
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