Тёмный

Creating a Pop-Out Navigation and Filter Bar Using Power BI Bookmarks. 4 Ideas for Sections to Add 

Jason Davidson
Подписаться 10 тыс.
Просмотров 30 тыс.
50% 1

In this video, I'll explain how to create a neat pop-out sidebar within your Power BI reports.
This sidebar can be hidden or shown and is a great way to save real estate within your Power BI reports.
I'll cover adding:
1. Page navigation - a section that uses the Power BI 'Page Navigator' option to create a page navigation visualisation that automatically updates when you add or remove pages to your report.
2. Slicers - If you want to add slicers visulisation to filter specific columns but don't want to tie up page real estate.
3. One-click filter - A button that uses Power BI bookmarks to automatically applies a set of multiple filters to your report so you don't need to select multiple filters or slicers manually. This example is to filter on the critical maintenance work orders.
4. Filter reset button - This button will reset all your filters to their default value with a single click.
👍Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works!
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - What you'll learn in this video
00:47 - Setting the foundation of the menu
03:20 - Menu open and close bookmarks
05:00 - Creating a Selection Group
06:00 - Bookmark Options for Menu Buttons
07:06 - Adding Actions to Buttons
08:17 - Add and Configure Page Navigation
12:14 - Add and Configure Slicers
13:33 - One Click Filter Button
14:49 - Bookmark for One Click Filter
16:50 - Bookmark for Filter Reset Button
18:40 - Adding newly created visuals to menu group
20:10 - Difference Between Checking Bookmark Data Option
21:00 - Summary of Pop-Out Menu Bar Functionality
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my RU-vid videos:
effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-...

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

 

10 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 27   
@elisahorton4833
@elisahorton4833 Год назад
I wanted so many videos today on bookmarks and this was the only one that taught me exactly what I needed to know in a non confusing way.
@josealfredojimenezmorales458
@josealfredojimenezmorales458 2 года назад
This is awesome!, thank you
@pbiqueryous
@pbiqueryous 2 года назад
Amazing! Thank you Jason - always look forward to your most helpful videos with ingenious tips and tricks. This quick tip is seriously tidy and massively improves the user experience. Looking forward to more videos!
@jasondavidsondata
@jasondavidsondata 2 года назад
Hi, thanks so much for the kind comments. I'm really happy you ate getting something from these videos. 😁
@mrabia182
@mrabia182 4 месяца назад
Soo useful thank you so much
@Q1ller
@Q1ller Год назад
Your channel is one of, if not the, most helpful I've found. Thank you!
@jasondavidsondata
@jasondavidsondata Год назад
Wow, thank you so much for your really kind comment! I'll hopefully be able to keep providing you with helpful info. Cheers Jason
@stlaurent26
@stlaurent26 Год назад
Thanks you!
@deannapatterson3643
@deannapatterson3643 Год назад
Perfect! Thank you!
@jasondavidsondata
@jasondavidsondata Год назад
Thanks for your kind comment 🙂
@alexrosen8762
@alexrosen8762 2 года назад
Very useful tutorial. Thanks a lot!
@jasondavidsondata
@jasondavidsondata 2 года назад
Great stuff. I'm glad you found it usefull.
@lrincon4901
@lrincon4901 Год назад
Amazing! Thanks a lot
@jasondavidsondata
@jasondavidsondata Год назад
Thanks for the comment! I'm really happy you enjoyed the video. 🙂
@tamararodrigues3471
@tamararodrigues3471 Год назад
Great video, thanksss!!
@jasondavidsondata
@jasondavidsondata Год назад
Thanks for your comment 👍 glad you liked it.
@user-qt9cz2kp6w
@user-qt9cz2kp6w 8 месяцев назад
Amaazing info!!!!
@jasondavidsondata
@jasondavidsondata 8 месяцев назад
Thanks so much, glad you enjoyed it 😊
@vangelaobli
@vangelaobli 9 месяцев назад
this is pretty neat! however, when I try this page navigation setup, whenever I go back to the previous tab, the pop up is still on. I want that to be off on every page nav click. otherwise, it looks messy when you pop it up, change tab, then return to previous tab with that pop up still open. any ways to fix that?
@sebastiandabrowski731
@sebastiandabrowski731 4 месяца назад
Hi, great video! I have a question - for every tab that you have i.e. 'Work Order Details', 'Backlog Schedule' ..... 'Help' - let's say you had 25 of them, and you wanted each 5 of those bookmarks to be grouped into some group, how would you make a Page nav so that you have each Group as a dropdown menu, so once you click, you see the 5 bookmarks belonging to that group?
@barryramsay
@barryramsay Год назад
Thank you for the video, I'm a bit of a beginner to PowerBi so this has been really helpful. Does the Menu then work on every page or do you need to copy the functionality and menu to every page?
@jasondavidsondata
@jasondavidsondata Год назад
Hi Barry, thanks for your comment. You'd need to copy The elements to every page. I'm afraid.
@RavinderKumar-gl8cy
@RavinderKumar-gl8cy Год назад
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population. If I select any state from slicer , then in the table, respective district list should appear and there population.
@sanikakalvikatte7211
@sanikakalvikatte7211 6 месяцев назад
Is it possible to replace the ctrl+ click with just a click?
@jasondavidsondata
@jasondavidsondata 6 месяцев назад
It will be a click when you publish it to the power bi service, its only ctl click in power bi desktop.
@kevinliew3692
@kevinliew3692 Год назад
I've found an issue: - Open the pop out navigation -> go to any other Page -> go back to previous page you came from -> you'll see the pop out navigation is still there is there any tricks to close it automatically?
@jasondavidsondata
@jasondavidsondata Год назад
Hi Kevin, if you create your own navigation buttons linking them to bookmarks it should be possible set a bookmark to the page with the navigation hidden. However, if you navigate using the tabs I think it remembers the last view.
Далее
DEFINITELY NOT HAPPENING ON MY WATCH! 😒
00:12
Просмотров 13 млн
Luiza Rasulova #luizarasulova
00:37
Просмотров 2,6 млн
Creating a Custom Filter Panel in Power BI
21:25
Просмотров 83 тыс.
Build a Slicer Panel in Power BI Like a PRO
20:40
Просмотров 54 тыс.