Creating ONE PAGE with MULTIPLE TABS in Power BI Report using BOOKMARK NAVIGATOR BUTTONS
Вставка
- Опубліковано 7 лип 2024
- Step by step tutorial to create a must have one page INFO page to answer FAQ with multiple tabs using Power BI Navigational Bookmark tool.
In my previous video about Power BI INFO PAGE, I have shown you a very useful info page… that has multiple tabs in Power BI
And we can click the various tabs.. and it will then display various information.
In this video, I will show you how to recreate the one page info page from scratch....in Power BI.
A quick and easy way to create navigation buttons that look like tabs on top of each report card.
I will also show you how to customise your report to include only your desired pages and exclude selected pages from the navigational bookmarks, using bookmark group feature in Power BI.
I will show you the secret to creating a page with multiple tabs in Power BI using Navigational bookmark feature.
There are 6 steps involved:
Step 1 - Create 1 page for each tab
Step 2 - Create 1 bookmark for each tab
Step 3 - Group the relevant bookmarks together
Step 4 - Insert Navigational Bookmark & format it nicely
Step 5 - Copy & paste navigational bookmark to each relevant page
Step 6 - Show the page associated with the first tab and hide all other pages
Once you have mastered this concept, you can also apply them to create multiple reports on the same page in Power BI. For example a report that shows sales charts and P&L charts in different tabs. If there in sufficient interest, I may create a video on this in the future...
In the meantime, hope you find the video useful & please do subscribe so that you don't miss out on my future Power BI and Excel videos...
Cheers,
Isabella Susilowati@LighthouseAnalytix
#powerbitutorialforbeginners #powerbitutorial #powerbi
Timelines:
00:00 Intro
00:23 Step 1 - Setting up each tab
03:11 Step 2 - Creating Bookmark
04:45 Step 3 - Grouping Bookmarks
05:25 Step 4 - Insert Bookmark Navigator
07:31 Step 5 - Cloning
07:55 Step 6 - Show and Hide
08:58 Epilogue
LA63b
Unfortunately I could not use this technique for interactive reports as the box is an invisible barrier. I had assumed it would work after deploying. Is there a workaround?
have you tried making the shapes unclickable? I made a video about it... ua-cam.com/video/jVfov5xe2UQ/v-deo.html
Thanks, Isabella - that was the ticket!
Very well explained. Very useful video. Thank you!
You are welcome!
Thank you, I understood everything and didn't even need to pause once. Great tutorial!
you are welcome - great to hear that !!
This is exactly what I was looking for! Thank you!
You're welcome!
Very Nice! I could clearly understand the concept of using bookmarks as tabs. Thank you Isabella for this really helpful video! Looking forward for more! 🙂
You're very welcome!
Hello Isabella, thank you for this video. My original Power BI app look clunky with all the buttons and using your technique, I made it looks so streamlined and nice. I searched a few hours for ideas and your design was easy to implement and navigate. Thank again!
You're welcome! So glad to hear that you find the video useful...
Thanks a lot. Nice info..👏👏
Very helpful video. Looking forward to implement it on my Power BI report. thanks a lot
awesome :) !!
Thank you very much Madam, for the very comprehensive video. I'm now ready to advance my Power BI dashboard to the next level.
Awesome !!! All the best..
This is the best video I've watched about bookmarks, Thank you🌹
Wow, thank you!
Very informative! Thank you!
Glad you enjoyed it!
Fantastic! Thank you so much!!!!!
You're very welcome!
Brilliant, thank you!
You're very welcome!
This video came at the right time. Thank you so much
So glad to hear that !! Have fun with putting your new knowledge into action :)
Thank you very much!!!
you are most welcome...
You are the best!
Aw... Thank you !!!
Very concise and apt. Weldone
Thank you for your kind words
This was so good. Thank you
You're so welcome!
Thanks a lot. This is very helpful
You are welcome!
This is awesome!
Thank you :)
Thanks for the video. I also like the sound of your voice, I could listen to your voice all day. All the best.
Aw.. .thank you !! all the best in your power bi learning journey....
hi dear, thanks a lot for this video. I was making a presentation and this was the easiest way I found out so many other videos... lots of love and success to your page.
Glad it was helpful! All the best with your presentation
Thank you for your time and effort. Nice to know the technique / Feature
My pleasure!
Thanks for your good suggestion.
You are welcome !!!
Muito Bom. Você me judou a melhorar o meu relatório, sou muito grato.
Você é bem vindo. Fico feliz que você possa usar o vídeo para melhorar seu relatório :)
❤❤❤ love this session🎉
Glad that you enjoyed the video !!!
Nice and simple thanks
Welcome 😊
Thanks a lot
Most welcome
I will use this in my report
Awesome :)
Why did you not use “page navigator” instead of “bookmark navigator”? (I imagine you could have added page navigator, and hidden all pages except the first one, without having to create bookmark groups).
Just curious about the advantage of a bookmark navigator in this case.
Btw, thank you so much for all your videos - I love how thorough and clear all your explanations are, and your voice is perfectly modulated, it is a pleasure to listen to your narration. Looking forward to new videos 👌😊
If we use page navigator... it will create buttons for every single pages, and we may end up with too many 'tabs'' or navigational buttons.
In this case, for my INFO page, I only want buttons for selected pages, thus why I opted for the bookmark navigator instead of the page navigator
Thanks Ma'am ❤
you are welcome
Thanks madam for this info
Welcome 😊
Awesome 👍
Thanks 🤗
Awesome❤
😍
Thank you. So easy to understand. Page navigator doesn't seem to work. Is there a video for it? 😊
Not yet! But if it doesn't work in Power BI Desktop... try using pressing Ctrl + click instead of just clicking the mouse...
Lovely
Thank you :)
Hi! Thanks so much for this amazing video. I have a question and I am hoping you can advise - I am looking to create multiple pages with multiple tabs (Ex. 4 different tabs for 4 different categories and information changes for each category+tab) Can you please share the process for the same? Thanks so much in advance!
Yes you can definitely do that...
You simply need to create separate set of navigational bookmarks for each group of tabs.
My recommendation is to start working on the first page first. Get it working... with the multiple tabs...
and then work on your second page.
All the best.
@@LighthouseAnalytix thanks very much! Was able to get it working!
Hi Isabella. Very helpful video. However, I found 1 problem when I implemented it on my power bi report. So I placed bookmark navigator of Page1 and all other hidden pages (Page2, Page3) on the non-hidden original page Tab Page1. I clicked on Page2 bookmark and Page2 content got rendered just fine on Page1 Tab. Good so far. Now I went to a random Page4 of report and came back to Tab Page1. Page1 content opens fine but shows Page2 bookmark selected. It should show Page1 bookmark navigator selected because Page1 content gets rendered OR it should continue to show Page2 content since Page2 bookmark is selected. Either should be the right case. Please try it out and help to solve this.
Whilst it can be a bit problematic in PBI desktop... it may perform ok in PBI Service. Have you tried publishing it to PBI service and then UAT it?
@@LighthouseAnalytix yes Isabella. This experience is from a published PBI report to PBI service. Can you pls try my usecase on a published one. You'll find the same issue. Kindly help how this can be fixed.
You're the Bob Ross of dashboarding.
Thank you for your compliment !!! I had never heard of Bob Ross before and decided to google him earlier. OMG he is such an amazing artist. The way he painted was mesmerizing. I ended up watching this entire video... ua-cam.com/video/lLWEXRAnQd0/v-deo.html
Based on your example, when i move from for example Source Data tab to other page for example P&L_Dashboard and then come back to Info page i will see content from Last Refreshed tab but on bookmark navigator the Source Data button will be still marked 😔 This suggests the viewer that he sees different tab than he actually sees. Unfortunately the bookmark navigator remembers which button was last marked on specific page. Is there a solution to have always first button on bookmark navigator marked when i come back to specific page?
Hi Adam, whilst it appears problematic when viewed from Power BI desktop... the report behaves differently in Power BI service. Whenever you navigate to other pages, e.g. P&L_ByGL and then returning to Info page. Power BI remembers the tabs that you last navigated. E.g. if the last tab that you clicked was Source Data... it brings you back to Source Data. Give it a go and let me know what you think.
Can I have personalized coaching for power bi
Hi Mayur... thanks for asking. I'm feeling flattered. Unfortunately at the moment, I'm really flat out with work, thus have little time available for individual coaching. I will let you know if my situation change in the future.
Mam, for selecfion can we press ctrl button
Hello... perhaps you can give it a go and see what happens
Hello mam, could you please upload a tutorial for creating dashboards only using the drop down navigation. I am not able to do it in my Power BI Desktop. i need it only with the drop down navigation and all visualizations to change accordingly to each drop down click in just one page.
I'm not really sure what you meant... can you please tell me more
Try adding Slicer visual and Add the category field to filter . Try changing the Style of slicer
Hi, I did not understand why we put everything in the big textbox, to begin with. I don't see a purpose to that. Can someone explain?
Without pressing ctrl button its effectrd or nt
Hello... I'm not sure I fully understand what rd or nt mean
@@LighthouseAnalytix Is it necessary to press the ctrl key to click the buttoms.
Only if you are in Power BI desktop. You don't have to do it once the report has been published to Power Bi Service.
Why you have to create boxes?
She's creating the effect where each box is acting as a window for the page she is clicking on. It's not possible to use the area outside of the canvas (the perforated lines), so she is manufacturing the appearance that the buttons are outside of the pages and the pages are inside the box, If that makes sense.
Thank you... beautifully explained indeed.