Тёмный

Creating ONE PAGE with MULTIPLE TABS in Power BI Report using BOOKMARK NAVIGATOR BUTTONS 

Подписаться
Просмотров 77 тыс.
% 1 102

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

Опубликовано:

 

29 сен 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 100   
@WaroPhobe
@WaroPhobe 10 месяцев назад
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?
@LighthouseAnalytix
@LighthouseAnalytix 10 месяцев назад
have you tried making the shapes unclickable? I made a video about it... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jVfov5xe2UQ.html
@WaroPhobe
@WaroPhobe 10 месяцев назад
Thanks, Isabella - that was the ticket!
@talvinmudhar4827
@talvinmudhar4827 Год назад
Thank you, I understood everything and didn't even need to pause once. Great tutorial!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
you are welcome - great to hear that !!
@elizabethkennedy3354
@elizabethkennedy3354 Год назад
This is exactly what I was looking for! Thank you!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You're welcome!
@vijayarjunwadkar
@vijayarjunwadkar Год назад
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! 🙂
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You're very welcome!
@jraj2380
@jraj2380 8 дней назад
Thanks a lot. Nice info..👏👏
@chicagorealtynow
@chicagorealtynow 3 месяца назад
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!
@LighthouseAnalytix
@LighthouseAnalytix 3 месяца назад
You're welcome! So glad to hear that you find the video useful...
@engmahrouselsayed4172
@engmahrouselsayed4172 Год назад
This is the best video I've watched about bookmarks, Thank you🌹
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Wow, thank you!
@saurabhkejriwal1765
@saurabhkejriwal1765 8 месяцев назад
Very helpful video. Looking forward to implement it on my Power BI report. thanks a lot
@LighthouseAnalytix
@LighthouseAnalytix 8 месяцев назад
awesome :) !!
@estheroturu7866
@estheroturu7866 5 месяцев назад
Very informative! Thank you!
@LighthouseAnalytix
@LighthouseAnalytix 5 месяцев назад
Glad you enjoyed it!
@JuanHernandez-pf6yg
@JuanHernandez-pf6yg 29 дней назад
Very well explained. Very useful video. Thank you!
@LighthouseAnalytix
@LighthouseAnalytix 23 дня назад
You are welcome!
@ganpathji
@ganpathji Год назад
This video came at the right time. Thank you so much
@LighthouseAnalytix
@LighthouseAnalytix Год назад
So glad to hear that !! Have fun with putting your new knowledge into action :)
@carolusrex8178
@carolusrex8178 5 месяцев назад
Fantastic! Thank you so much!!!!!
@LighthouseAnalytix
@LighthouseAnalytix 5 месяцев назад
You're very welcome!
@silvestrecamposano6317
@silvestrecamposano6317 Год назад
Thank you very much Madam, for the very comprehensive video. I'm now ready to advance my Power BI dashboard to the next level.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Awesome !!! All the best..
@lovethisgame23
@lovethisgame23 Месяц назад
Brilliant, thank you!
@LighthouseAnalytix
@LighthouseAnalytix Месяц назад
You're very welcome!
@OliveEzetendu
@OliveEzetendu Год назад
This was so good. Thank you
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You're so welcome!
@BuiQuynhNhu
@BuiQuynhNhu Год назад
Thank you very much!!!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
you are most welcome...
@zakariafadili2762
@zakariafadili2762 Год назад
You are the best!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Aw... Thank you !!!
@karunakaranr2473
@karunakaranr2473 2 месяца назад
Thank you for your time and effort. Nice to know the technique / Feature
@LighthouseAnalytix
@LighthouseAnalytix 2 месяца назад
My pleasure!
@ramanvarun
@ramanvarun 11 месяцев назад
Thanks a lot. This is very helpful
@LighthouseAnalytix
@LighthouseAnalytix 11 месяцев назад
You are welcome!
@anthonychilaka
@anthonychilaka 10 месяцев назад
Thanks for the video. I also like the sound of your voice, I could listen to your voice all day. All the best.
@LighthouseAnalytix
@LighthouseAnalytix 10 месяцев назад
Aw.. .thank you !! all the best in your power bi learning journey....
@joshmarchini927
@joshmarchini927 2 месяца назад
This is awesome!
@LighthouseAnalytix
@LighthouseAnalytix 2 месяца назад
Thank you :)
@fernandoborges8924
@fernandoborges8924 Год назад
Muito Bom. Você me judou a melhorar o meu relatório, sou muito grato.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Você é bem vindo. Fico feliz que você possa usar o vídeo para melhorar seu relatório :)
@NehaThakur-sx5qc
@NehaThakur-sx5qc 7 месяцев назад
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.
@LighthouseAnalytix
@LighthouseAnalytix 7 месяцев назад
Glad it was helpful! All the best with your presentation
@MrHackmed
@MrHackmed Год назад
Very concise and apt. Weldone
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thank you for your kind words
@thanomnoimoh9299
@thanomnoimoh9299 Год назад
Thanks for your good suggestion.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You are welcome !!!
@rajivn8833
@rajivn8833 Год назад
❤❤❤ love this session🎉
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Glad that you enjoyed the video !!!
@jurjendeboer4009
@jurjendeboer4009 6 месяцев назад
Nice and simple thanks
@LighthouseAnalytix
@LighthouseAnalytix 6 месяцев назад
Welcome 😊
@euphonesse55
@euphonesse55 Год назад
I will use this in my report
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Awesome :)
@mekdadmarey7148
@mekdadmarey7148 4 месяца назад
Thanks a lot
@LighthouseAnalytix
@LighthouseAnalytix 4 месяца назад
Most welcome
@chakri6002
@chakri6002 Год назад
Thanks madam for this info
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Welcome 😊
@ngwafabrice9561
@ngwafabrice9561 Год назад
Thanks Ma'am ❤
@LighthouseAnalytix
@LighthouseAnalytix Год назад
you are welcome
@user-en3pc7ko8e
@user-en3pc7ko8e Год назад
Awesome❤
@LighthouseAnalytix
@LighthouseAnalytix Год назад
😍
@lovecareshare
@lovecareshare Год назад
Awesome 👍
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thanks 🤗
@emilymalkin270
@emilymalkin270 Год назад
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 👌😊
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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
@Ayman154
@Ayman154 Год назад
Lovely
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thank you :)
@julie_chen
@julie_chen Год назад
Thank you. So easy to understand. Page navigator doesn't seem to work. Is there a video for it? 😊
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Not yet! But if it doesn't work in Power BI Desktop... try using pressing Ctrl + click instead of just clicking the mouse...
@deekshithvanamala5641
@deekshithvanamala5641 Год назад
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!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@deekshithvanamala5641
@deekshithvanamala5641 Год назад
@@LighthouseAnalytix thanks very much! Was able to get it working!
@SM-Learner
@SM-Learner 26 дней назад
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?
@aaron.debattista
@aaron.debattista Год назад
You're the Bob Ross of dashboarding.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lLWEXRAnQd0.html
@saurabhkejriwal1765
@saurabhkejriwal1765 5 месяцев назад
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.
@LighthouseAnalytix
@LighthouseAnalytix 5 месяцев назад
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?
@saurabhkejriwal1765
@saurabhkejriwal1765 5 месяцев назад
@@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.
@adamalbert9902
@adamalbert9902 Год назад
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?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@mayurt4628
@mayurt4628 5 месяцев назад
Can I have personalized coaching for power bi
@LighthouseAnalytix
@LighthouseAnalytix 5 месяцев назад
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.
@kisshor1000
@kisshor1000 Год назад
Mam, for selecfion can we press ctrl button
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Hello... perhaps you can give it a go and see what happens
@user-wo7sx6xs4w
@user-wo7sx6xs4w 6 месяцев назад
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.
@LighthouseAnalytix
@LighthouseAnalytix 6 месяцев назад
I'm not really sure what you meant... can you please tell me more
@sayhi365
@sayhi365 28 дней назад
Try adding Slicer visual and Add the category field to filter . Try changing the Style of slicer
@kisshor1000
@kisshor1000 Год назад
Without pressing ctrl button its effectrd or nt
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Hello... I'm not sure I fully understand what rd or nt mean
@kisshor1000
@kisshor1000 Год назад
@@LighthouseAnalytix Is it necessary to press the ctrl key to click the buttoms.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@morowar666
@morowar666 Год назад
Why you have to create boxes?
@talvinmudhar4827
@talvinmudhar4827 Год назад
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.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thank you... beautifully explained indeed.