Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop
HTML-код
- Опубликовано: 6 сен 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
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 🥲
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.
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!
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!
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.
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 😭
Yoooooo! This one was a page turner!
hahahahaha indeed 🤣
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 !!!
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.
This is so useful to navigate to other pages..than button option. Thanks mate .
Agreed! 👊
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
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.
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.
5:36 - That was what I was waiting for ;)
hahahaha It's BANANAS!
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?
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!
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!
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!
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.
Thanks Patrick. You always blow everyone with new tricks. Loved it!
Awesome! I actually started to get excited when you showed that it would just use the table!
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
Patrick.. your tips always reduce our work efforts.
Thanks Man !!!!!
Thanks Patrick .. I used this stuff today after viewing your video
Excellent. Very useful specially when you have 10+ pages on your report. Thank you!
thanks Patrick for 2 min Tuesday video... this is really nice.
Most welcome Ketan! 👊
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!
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.
Awesome tip! Thanks for sharing! I hope this gets developed further allow for nested lists, etc.
Great! Thank you. Will definitely use this 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.
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 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?
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...
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!! Great feature, thank you for sharing.
Most welcome! Thanks for watching 👊
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
@Guy in a Cube, Thanks for this post.
Can we skip the button and navigate using slicer only?
Always learn something new every time watch your channel :)...Keep it up !!
🙏 ❤️ From India , Thanks to sharing your knowledge Patrik ❄️❄️
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.
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!
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
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
Good way to navigate.thanks for sharing
Very helpful , keep the good work going on
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
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
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?
Love it! Another amazing video. Keep up the great work, All!
Appreciate that! Thanks for watching 👊
Perfectly explained! Thanks Patrick!
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.
Brazil here!✋
Hello Brazil! 👊
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?
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 ?
Well this is a game changer for bulky reports.
This is excatly what l was looking for......I think it can be also done with bookmarks.....
Nice feature, makes it more easy to add navigation and therefore an interactive report.
Is this coming available for bookmarks as well?
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
It's very useful thanks a lot
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
Better to not need the GO button and the drop-down selection changes pages, like a horizontal slicer.
Great video, you guys in a cube explain thing easily. Great content
This is very cool and smart! Less clicks, the better!
My team are going to love this!
Got it & loved it! Thanks
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??
Loved it.....Thank you So much Guy in a Cube
Navigation got even better in mobile Power BI reports. Take a look: ruclips.net/video/S5_WYyPc67o/видео.html
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.
Is there a way to navigate without clicking on "Go" button? Like just selecting from the list?
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
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.
Wow! Very helpful. Thank you
This is amazing stuff! It saves up so much space!
Great work patrick, gonna implement in my latest report 😎
Fantastic video. Thanks for sharing
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.
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.
Nice One !! shame does'nt work in live cube connection !! can't add any data in Power BI ! any tips ??
Hey Patrick - do you know oif PBI desktop allows connecting to a PBI dataset in the recent version?
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.
This is so awesome - thank you!!!
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?
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
@@MatheusMarchezi How can I disable the new pane?
@@jperezts go to settings and to then preview features. you will see "New Format pane" as one of the options, uncheck that
@@riverland0072 Thank you very much!👌👌👌👌
Great tip! Thank you so much!
Hey Patrick you are just amazing and thanks for tricks. My request could you please create video on power bi Visual Pagination?
Great job as allways , Question: is there any way to make this work in a dashboad too?
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!!
Thanks, that's a very usefull video
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.
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.
B A N A N A S !!! awesome... will try this today.
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
Will this work with DirectQuery (and not scheduled refresh)?
Seems like the column is grayed out and the action can't be set
Nice trick there, saves a lot
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?
Loved it. Thanks Patrick.
Hi thanks for the video.
I can see in this report you tiles are having shadows how you get that,
Please help me on this.