Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop
Vložit
- čas přidán 22. 06. 2020
- 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/cnavsample
📢 Become a member: guyinacu.be/membership
*******************
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/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #2M2 #GuyInACube - Věda a technologie
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!
Thanks Patrick. You always blow everyone with new tricks. Loved it!
You are a legend Patrik ... such a simple way to navigate between the pages .. too good mate, thanks a ton !!!
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!
Awesome! I actually started to get excited when you showed that it would just use the table!
Patrick.. your tips always reduce our work efforts.
Thanks Man !!!!!
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.
Awesome tip! Thanks for sharing! I hope this gets developed further allow for nested lists, etc.
As a data scientist that loves GameCube and Marvel... I'm a big fan of your guys' work! Very much appreciated!
Excellent. Very useful specially when you have 10+ pages on your report. Thank you!
Perfectly explained! Thanks Patrick!
Great! Thank you. Will definitely use this technique
Great video, you guys in a cube explain thing easily. Great content
Loved it. Thanks Patrick.
This is amazing stuff! It saves up so much space!
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 😭
Love it! Another amazing video. Keep up the great work, All!
Appreciate that! Thanks for watching 👊
Always learn something new every time watch your channel :)...Keep it up !!
Great tip! Thank you so much!
Got it & loved it! Thanks
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!
Loved it.....Thank you So much Guy in a Cube
Very helpful , keep the good work going on
Thanks Patrick .. I used this stuff today after viewing your video
Amazing, exactly what I needed!!!
Very helpful, thanks man 👏🏼👏🏼
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 🥲
Love it!! Great feature, thank you for sharing.
Most welcome! Thanks for watching 👊
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.
They should provide the same conditional formatting for bookmarks as well.
Wow! Very helpful. Thank you
This is so awesome - thank you!!!
Great work patrick, gonna implement in my latest report 😎
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 🤣
My team are going to love this!
Fantastic video. Thanks for sharing
Good way to navigate.thanks for sharing
Mind blown!!! That is awesome!!!
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.
This is so useful to navigate to other pages..than button option. Thanks mate .
Agreed! 👊
I totally love it!
Absolutely Brilliant!
It's very useful thanks a lot
Awesome! Thanks.
Thanks, that's a very usefull video
Awesome Patrick!
thanks Patrick for 2 min Tuesday video... this is really nice.
Most welcome Ketan! 👊
You are amazing. Love it.
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?
You're awesome, man!
Great!!! I would love to do something like this, but choosing the bookmark.
Me too!
🙏 ❤️ From India , Thanks to sharing your knowledge Patrik ❄️❄️
Awesome. Thanks as usual ;)
Wow! This is great!
this is amazing!!
Great technique!!
Very nice! 👏👏
VERY helpful, thank you
Glad you liked it Justin! Thanks for watching 👊
This is amazing!!:)
This is very cool and smart! Less clicks, the better!
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.
Love the tip!
Nice stuff !!
Nice trick there, saves a lot
5:36 - That was what I was waiting for ;)
hahahaha It's BANANAS!
its so fantastic, watsup my friend. i from Brazil tanks so much
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!
Nice feature, makes it more easy to add navigation and therefore an interactive report.
Is this coming available for bookmarks as well?
Very good, bro!!
Excellent !
Great tip!
Very cool Patrick!
This is B A N A N A S!
Thanks Patrick🙌😉
Great feature , I like it
So useful, love it
Woot! Glad you liked it Susan!
B A N A N A S !!! awesome... will try this today.
Great tip
Amazing!!
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
Great one
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!
This is awsome.
This is awesome
This is awesome.
I love it. Amazing
Woot! 👊
million thanks....
Very great
This is excatly what l was looking for......I think it can be also done with bookmarks.....
amazing.. thanks
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!
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.
Wow - Amazing
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.
Amazing!!!
Awesome. Clicks are good👍🏻
Appreciate that! Thanks for watching 👊
Love this tip :)
Glad to hear that 👊
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?
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
Espectacular