How to create Power BI In-Page Navigation with Bookmarks and Buttons

Поділитися
Вставка
  • Опубліковано 17 лис 2024

КОМЕНТАРІ • 187

  • @adityanjsg99
    @adityanjsg99 2 роки тому +20

    I did this and my boss was way impressed.. Thank you.

  • @karinaakhmadullina6180
    @karinaakhmadullina6180 6 місяців тому +2

    One of the best tutorials on Power BI I have ever come across! Thank you a million times!

  • @anonymous-user
    @anonymous-user Рік тому +1

    Time and time again I come to this video. 11:30 is the spot!

  • @oluwatuyiayomide5385
    @oluwatuyiayomide5385 2 роки тому +1

    I finished the video, and zi was just clapping. You did a good job

  • @rookiesurgeon2090
    @rookiesurgeon2090 2 роки тому +2

    I've been looking for something like this for months. You're a genius!!

  • @carmenc3911
    @carmenc3911 Рік тому +1

    Thanks for the weary to understand tutorial.

  • @adhishnanda
    @adhishnanda 3 роки тому +3

    Beautifully Explained! Thank you for this.

  • @BryantAveyPlus
    @BryantAveyPlus 3 роки тому +9

    This is kinda brilliant! Love the idea of using visibility of the charts and button states then storing those as bookmarks. Never thought of doing it that way. Love the results. Really cool.

    • @ExcelFort
      @ExcelFort  3 роки тому

      Appreciate it!
      I am planning to create more videos on different visualization elements of this kind.
      Subscribe & hit like :)

  • @ramsharyt
    @ramsharyt 10 місяців тому

    great precise video with Bookmarks to demo space management along with tabs and Smart narratives

  • @marynakostiuk6807
    @marynakostiuk6807 Рік тому +1

    Thank you for the step-by-step explanation! Great content!

  • @karensasci
    @karensasci 2 роки тому +5

    Absolutely amazing!! I was able to clean up a dashboard while adding more relevant visuals for different users and keeping it interactive and simple. Thank you so much!

  • @mauricioantoniobeltranzepe7746
    @mauricioantoniobeltranzepe7746 3 роки тому +2

    I just want to say thank you for this video; it helps me a lot; thank you very much for sharing.

    • @ExcelFort
      @ExcelFort  3 роки тому +1

      You are most welcome, appreciate it. You share my channel with others

  • @smoker6269
    @smoker6269 2 роки тому +2

    This is very clever and just what I needed. Thank you.

  • @a.j.ferrara397
    @a.j.ferrara397 8 місяців тому

    This was a great video. It was exactly what I needed to learn. Thank You!

  • @PedroCarneiroJr1971
    @PedroCarneiroJr1971 Рік тому +1

    Excelent directions! This one goes to my utility belt. 🔝

  • @eagillum
    @eagillum Рік тому

    Ooh I like this! I always want more maps than my page can handle.

  • @red0527
    @red0527 Рік тому +1

    Truly helpful, very clear and precise. Thank you very much for sharing the knowledge.

  • @kundanparashar6851
    @kundanparashar6851 Рік тому

    Wonderful video , it helped me lot to enhance my reporting skills .

  • @hendrag593
    @hendrag593 2 місяці тому

    Thanks for this great video

  • @yogeshpandey3050
    @yogeshpandey3050 2 роки тому +2

    Greatly explained! I was looking for something like this

  • @carltonseymour869
    @carltonseymour869 2 роки тому +1

    Fantastic video. Why was the inactive button made? I do not see it being used.

    • @ExcelFort
      @ExcelFort  2 роки тому

      Thanks for your encouragement!
      The inactive buttons indicate the availability of tabs, without them, you will not know what tabs are there.

  • @joanneosborne2428
    @joanneosborne2428 2 роки тому +2

    This was amazing. Thank you for this. 🌝

  • @indicadorespowerbiconcicar6259
    @indicadorespowerbiconcicar6259 2 роки тому +1

    Thanks! I really appreciatte your contribution. I would like state that in the 2022 version it is very important to set ON the option "Format Button/Button/Style/Text" in order to write inactive buttons' names and keep "Format Button/Button/General/Title" option set off. Otherwise is not possible to Ctrl+Click inactive buttons. Bookmarks seems not to work properly but the issue is in inactive buttons.

    • @ExcelFort
      @ExcelFort  2 роки тому +1

      Appreciate it

    • @encryptedunlimited1094
      @encryptedunlimited1094 2 роки тому

      still doesn't work for me

    • @jayabhagchandani1949
      @jayabhagchandani1949 Рік тому

      Thank you so much for this tip.
      I was struggling for 2hrs, because I had done the opposite of it.
      Later on I reedited it as per this and it worked..
      Once again, Thanks a lot!!

  • @luismanueldiazbaron9588
    @luismanueldiazbaron9588 5 місяців тому

    Nice!! Straight to the point.

  • @muhammetmuslu4429
    @muhammetmuslu4429 Рік тому

    It was very useful for me, thank you very much. It was a feature I wanted to learn for a long time.

  • @dipongkarroy1720
    @dipongkarroy1720 7 місяців тому

    Just Wowwwwwwwwwww, you save my ton's of time, Thanks

  • @catalinagarcia3924
    @catalinagarcia3924 2 роки тому +1

    Super helpful!!! Many thanks!!

  • @nareshch-zp7yi
    @nareshch-zp7yi Рік тому

    this is helpful. nice explanation...thank you

  • @zeuz4218
    @zeuz4218 Рік тому

    Thank you this helped me a lot.

  • @CollinQuiring
    @CollinQuiring Рік тому

    Thank you! This was very helpful!!

  • @raoul-thomascampian1726
    @raoul-thomascampian1726 9 місяців тому

    Amazing. Thank you very much!

  • @channelino24
    @channelino24 Рік тому +1

    Thank 😂you very much for that. Already my preferred BI Tutorial 😊.

  • @brendas6461
    @brendas6461 Рік тому

    Most helpful, thank you!

  • @ALEXMELO1234
    @ALEXMELO1234 2 роки тому

    Thank you very much!! Excelent explanation!

  • @suhilahamed4307
    @suhilahamed4307 2 роки тому

    Just amazing.starting to love using powebi. Thanks for the very well explained video.Looking forward to many more such videos.

    • @ExcelFort
      @ExcelFort  2 роки тому

      Welcome to the Power BI family!

  • @ssomtom
    @ssomtom 2 роки тому

    Wonderful, obvious explaination. Thx

  • @rakeshchaudhary1386
    @rakeshchaudhary1386 23 дні тому

    Thank you soooooo much sir

  • @jayeshsuthar9198
    @jayeshsuthar9198 2 роки тому

    Excellent technique thanks

  • @kathir3187
    @kathir3187 3 роки тому +2

    Excellent 👌

  • @ChrisSmithFW
    @ChrisSmithFW 2 роки тому

    This is really awesome. Love it and love your tutorials. I implemented this and your Nav page flyout recently. A little puzzled though, particularly pertaining to the bookmarks. On each occasion, when creating the in-page and site nav panel, the selections I had to use to get the bookmarks to properly work were each of "display," "current page," and "all visuals." When using your recommendations, they didn't work for me. Upon update, the prior bookmarks created would save to the new update, so clicking on each advanced me to the most recently saved update version. Obviously, I don't understand the options well enough. Scratching my head about this but I'll figure out the disconnect soon enough.
    Thanks again for taking the time. You and Reza just may be my favorite instructors. Much appreciated!

    • @ExcelFort
      @ExcelFort  2 роки тому

      Thanks for watching my videos :)
      I didn't quite understand the concern you had, however, please reach out to me if you need any help.

  • @CountryViewMeadows
    @CountryViewMeadows 3 роки тому +1

    Awesome! thank you so much!!!

  • @kimrainman
    @kimrainman 3 роки тому +1

    This is GENIUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUS
    I owe you a huge debtrttttt

  • @maryhelmi12
    @maryhelmi12 3 роки тому +1

    easy to follow through

  • @ExcelFort
    @ExcelFort  3 роки тому +2

    You can download the Power BI file using the link in the description and have a look at the completed report. Keep your questions ready to have them clarified during the premier session.

  • @iliasz.5232
    @iliasz.5232 2 роки тому

    Boss: You're fired!
    Fowmy: Fine.
    😄

  • @sathishkumarpati
    @sathishkumarpati Рік тому

    Thank you very much 🙏

  • @elbezz
    @elbezz Рік тому

    Thanks Man, very helpful!

  • @garybou8559
    @garybou8559 13 днів тому +1

    Excellent video, only properties and tabs on new version of desktop changed with
    Version: 2.137.1102.0 64-bit (October 2024)

  • @Bharath_PBI
    @Bharath_PBI 3 роки тому +1

    Thank you 👍

  • @stasynech
    @stasynech 2 роки тому +1

    Thank you for this amazing video, could you please share if there is any ways to make slicers apply to all the bookmarks, when I switching between bookmarks I should reapply all the slicers

    • @ExcelFort
      @ExcelFort  2 роки тому +1

      Thanks for your kind words!,
      When visuals are hidden, the slicer selection applied to them cannot be retained. In order to solve this problem, you could separate slicers based on what fields you use in your visuals within each page of your report.
      I would suggest you to watch the latest video on the same topic where I have used the Bookmark Navigator:ua-cam.com/video/P4YlVAbvvK4/v-deo.html

    • @stasynech
      @stasynech 2 роки тому

      @@ExcelFort Thank you are just eye opener!!!!

  • @HuffrsZoe
    @HuffrsZoe Рік тому

    AWESOME!!! Thank you!!!

  • @aayushigandhi1414
    @aayushigandhi1414 Рік тому

    Brilliant video

  • @indianarasantos2798
    @indianarasantos2798 2 роки тому +1

    Thanks a lot, this is amazing!

  • @smeeshTV
    @smeeshTV 2 роки тому +1

    Super helpful!

  • @perfectionist6624
    @perfectionist6624 2 роки тому

    please add such out of the box visual ideas. Thanks a lot....

  • @sushantshinde1
    @sushantshinde1 Рік тому

    Good work 🙌🏻🙌🏻🙌🏻

  • @rachelwu6550
    @rachelwu6550 3 роки тому +1

    Legend! Thx mate!

  • @ВязаныйТапок
    @ВязаныйТапок 3 роки тому +1

    Great!! Thank's a lot!

  • @khorshidsun3143
    @khorshidsun3143 2 роки тому

    Thanks. Can we go from one card in one page to its variance chart in another page?

  • @SambarajuKanaveni
    @SambarajuKanaveni Рік тому +1

    it helps boss..👍👍

  • @pavanyuva011
    @pavanyuva011 Рік тому +1

    why did u created two set of buttons. cant we do with single set of button. ? pls confirm

  • @akhilanand298
    @akhilanand298 2 роки тому

    This is awesome. Thanks for the great content.

  • @qaisurrehman
    @qaisurrehman 2 роки тому

    very beautiful!, liked and subscribed worth every minute of it thank you!

  • @_Areknames_
    @_Areknames_ 9 місяців тому

    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

  • @gettokeroro5007
    @gettokeroro5007 2 роки тому +1

    3milion thank save my life ❤️❤️

  • @bluetaurean
    @bluetaurean Рік тому +1

    Amazing

  • @Tanveer9837
    @Tanveer9837 Рік тому

    Excellent!

  • @TrassBI
    @TrassBI 3 роки тому

    Very helpful. Thanks for sharing.👍

  • @kabilanv6453
    @kabilanv6453 2 роки тому +1

    I really liked your video sir. One question, could you please tell why are we creating the inactive buttons separately?

  • @HemantRangdal
    @HemantRangdal 4 місяці тому

    Why do you deselect the data while marking bookmarks?

  • @syrinehasnaoui898
    @syrinehasnaoui898 Рік тому +1

    Hello
    Thank you for the video! But i followed everything and yet my buttons don't work when i hit ctrl + click. Do you know why ? Thank you

    • @ExcelFort
      @ExcelFort  Рік тому

      Did you download my file and follow the steps that I showed on the video?

  • @joelluis4938
    @joelluis4938 2 роки тому +1

    Hi! Amazing Video.. Could you please explain why did you turn of Date, Current Page and Selected ''Selected Visuals'' ? That's the only thing i didn't understand , i mean the reason for doing that.

    • @ExcelFort
      @ExcelFort  2 роки тому +1

      DATA is not selected to avoid capturing the current filters on the data
      SELECTED VISUALS record only the selected visuals so that the bookmark won’t affect the others

  • @helenamacieira1596
    @helenamacieira1596 3 роки тому +2

    thank you for the video, one doubt, when you select one of the characteristic of one tab does not filter the other tabs, like it happens on the other visualizations. How can we change this? Thank you

    • @ExcelFort
      @ExcelFort  3 роки тому +2

      Great question, when you click on a visual to cross filter and hide that visual, the filters are cleared. Here we use bookmarks and visibility to hide visuals. As a work around, you can place a slicer on the report for the user to filter the required field.
      Hope some improvements will come up in Power BI soon to handle this limitation.

    • @iliasz.5232
      @iliasz.5232 2 роки тому

      Hey Helena
      How did you solve your situation?
      I have the same question you posed.

    • @iliasz.5232
      @iliasz.5232 2 роки тому

      @@ExcelFort
      I'm in a similar situation to what @Helena Macieira reported. Are there any news on this front?
      Thanks for this excellent video!

    • @ExcelFort
      @ExcelFort  2 роки тому +1

      @@iliasz.5232 Thanks, I will surely update as soon as there an update on this limitation

    • @iliasz.5232
      @iliasz.5232 2 роки тому

      @@ExcelFort Thank you.

  • @samuelTTekle
    @samuelTTekle Рік тому +1

    Is there a way to navigate through tab with out using the control button

    • @ExcelFort
      @ExcelFort  Рік тому

      You need to use Control button only in Power BI desktop, not required in the service.

  • @VarunSingh-be7xf
    @VarunSingh-be7xf 2 роки тому

    Brilliant!!!

  • @Imrannaseem818
    @Imrannaseem818 3 роки тому

    great video sir thanks

  • @ohmoneymoneyhome6430
    @ohmoneymoneyhome6430 3 роки тому +1

    hello, Thank you for sharing this video, it helps me a lot to understand the navigation. one question, to activate the bottom, how could i change to double click instead of the default way ctrl + click?

    • @ExcelFort
      @ExcelFort  3 роки тому +2

      Glad you like it,
      You need to use Ctrl Click when you develop the report, this method cannot be modified. Once you finalize the report to Power BI service, only single click is sufficient. Hope it’s clear ?

    • @ohmoneymoneyhome6430
      @ohmoneymoneyhome6430 3 роки тому

      @@ExcelFort clear. thank you ~

    • @TinyKideo
      @TinyKideo 2 роки тому

      Useful Comment Cheers!!

  • @TheMKTube
    @TheMKTube Рік тому

    Great Tutorial!! I implemented it as described. 17:51 I was wondering if there’s any way to make BI remember which filters the user had clicked as they go from one bookmark to another so the filters don’t keep getting reset? Would appreciate any input on this! Thank you 🙏

    • @TheMKTube
      @TheMKTube Рік тому

      I found the answer! You click the 3 dots for each Bookmark and uncheck “Data” and that excludes any filters the user had applied 👍🏼

    • @ExcelFort
      @ExcelFort  Рік тому

      Not that I know of

    • @TheMKTube
      @TheMKTube Рік тому

      @@ExcelFort I mentioned the solution in the follow up comment I made above it worked :)

  • @minhthanhnguyen7191
    @minhthanhnguyen7191 2 роки тому +1

    What if I choose another year?

  • @topeogutuga3517
    @topeogutuga3517 2 роки тому +1

    Please help, I created mine but the hidden graphs when displayed won't show in the rectangular box but rather individual spot before hiding

    • @ExcelFort
      @ExcelFort  2 роки тому

      Sorry, it's not clear enough for me, could provide more details?

    • @topeogutuga3517
      @topeogutuga3517 2 роки тому

      @@ExcelFort thanks for responding, I fixed it

  • @LearnAllways
    @LearnAllways 3 роки тому +1

    Could able to do some videos for Average time on

  • @priyankarane6820
    @priyankarane6820 2 роки тому +1

    I have downloaded the report but Bookmark is not working at my side. I am using Power BI Desktop version 2.103.661.0 64-bit (March, 2022)
    Please suggest the solution.

    • @ExcelFort
      @ExcelFort  2 роки тому

      Use CTRL + Left Click when you want to click on a button

  • @gaMEXDavid
    @gaMEXDavid 2 роки тому

    Why you un-thick data, current page and thick all visuals in every bookmark?

    • @ExcelFort
      @ExcelFort  2 роки тому +1

      DATA is unticked to avoid capturing data state from the model

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 2 роки тому

    How to create slicer connection to both table and pivot table?

  • @Honey-cc9ij
    @Honey-cc9ij 3 роки тому +1

    Using single button to perform page navigation nd Book marks, is it possible ..?

    • @ExcelFort
      @ExcelFort  3 роки тому +1

      Single button enables only page navigation with conditional formatting, it doesn’t support bookmarks yet :)

    • @Honey-cc9ij
      @Honey-cc9ij 3 роки тому

      Tq ExcelFort :)

    • @ExcelFort
      @ExcelFort  3 роки тому +1

      @@Honey-cc9ij
      You can watch this video to learn Page Navigation
      ua-cam.com/video/xCSYLrcLW00/v-deo.html

    • @Honey-cc9ij
      @Honey-cc9ij 3 роки тому

      Sure 😊

  • @AbdulKhan-fi1lg
    @AbdulKhan-fi1lg 2 роки тому +1

    Sir should i hide all the charts on the same position where we have created our shape and button because when i am trying to unhide then chart is displaying on same position where we hide them..

    • @ExcelFort
      @ExcelFort  2 роки тому

      Unfortunately, I don't completely understand it

  • @sureshrao174
    @sureshrao174 2 роки тому

    How can we jump directly from sales trend to salesvprofit and products by not clicking ctrl plus click how can we jump by just one click on icon ?

    • @ExcelFort
      @ExcelFort  2 роки тому

      In Power BI Desktop, you need to click CTRL but once you publish the report to Power BI service, single click would work.

  • @radhicalm
    @radhicalm Рік тому

    please please help sir. i am doing one project in that i am using this page navigation concept same as like this in this video and it is working very fine. but when i click on any tab the other visuals outside of this tab also getting changed . i applied edit interactions but it is not stoping changing. when i click the buttons the other viuals also changing .
    please help sir. what i have to check?

  • @psysuhanasafar5441
    @psysuhanasafar5441 Рік тому

    If don't want to use CRT+CLICK,
    JUST CLICK on button to change the visual, how i do that.

    • @ExcelFort
      @ExcelFort  Рік тому

      You only need to do it in Power BI Desktop, once you publish, you only have to click once without CTRL in Power BI service.

  • @AmanGoyal-k8l
    @AmanGoyal-k8l 2 місяці тому

    i am unable to make the bookmarks as it doesn't store the selected visuals! Can you please help me here

  • @dhirajshet3420
    @dhirajshet3420 2 роки тому +1

    Hi, I have to connect button to button. How to do that. For example I have defect in process in 12 months and DPMO for 12 months. Defect n DPMO are 2 button and there are sub button or say multiple button under defect for chart like FN error chart, FP error chart. Also few chart for DPMO with multiple button under DPMO button. However unable to link Defect button to error button like FN n dp button. I had tried grping them n then create bookmark but it's not working. Can u help here

    • @ExcelFort
      @ExcelFort  2 роки тому

      I didn’t quite understand your situation, could you send me an email with a. Sample file explaining your question and the expected results

  • @justineedward7984
    @justineedward7984 2 роки тому

    how to keep the slicer filter while navigating to every tabs. everytime i click the tab, the slicer filter is reset.

    • @ExcelFort
      @ExcelFort  2 роки тому

      If you follow the steps carefully, it should work, let me know how exactly you tried it

  • @alivdutta
    @alivdutta Рік тому

    Hello Sir,
    I downloaded your file, but the buttons are not working on my Power BI Desktop. Also, I have followed the same steps (both using buttons and using Power BI Navigator), but nothing worked. Could you please help me in this regards as to why the buttons are not working!

    • @michaelthompson7054
      @michaelthompson7054 8 місяців тому

      Nothing worked for me either. Spent hours on this doing it over and over but the bookmarks never actual allowed for switching back and forth using the buttons.

  • @aayushigandhi1414
    @aayushigandhi1414 Рік тому

    why do we need to assign bookmark to inactive buttons... i am bit confused and why do we need to deselect data ......

    • @ExcelFort
      @ExcelFort  Рік тому

      Please watch the updated video where I used the bookmark navigator
      ua-cam.com/video/P4YlVAbvvK4/v-deo.html

  • @sasmitadash492
    @sasmitadash492 2 роки тому

    I am not getting this visual, could anyone help me out? While I click on bookmarks it's not giving me correct result, even its not moving

    • @ExcelFort
      @ExcelFort  2 роки тому

      Thanks for watching the videos,
      Hope you followed the steps in the video. Make sure to open the selection page and select the objects before applying your bookmarks with ALL SELECTED option

  • @shunmugapriyas3732
    @shunmugapriyas3732 3 місяці тому

    I tried this,But only on clicking the bookmarks it is displaying the charts.On direct click of the button it is not displaying.How to test that?

    • @БогданЗалитайло
      @БогданЗалитайло Місяць тому

      I have the same problem. I have done everything like in tutorial step by step, but with no result (power Bi desktop)

    • @garybou8559
      @garybou8559 13 днів тому

      Cntrl + Select button

  • @hanana2675
    @hanana2675 2 роки тому

    Bookmarks are not working with me, what could be the problem

    • @hanana2675
      @hanana2675 2 роки тому

      Even though i select the visuals and click on update

  • @sunilmotwani8982
    @sunilmotwani8982 2 роки тому +1

    Sunil Motwani

  • @lucianlackman8103
    @lucianlackman8103 2 роки тому

    I have done this like a million times it doesn’t work. Thing thing is stressful jeez 😭😭

    • @ExcelFort
      @ExcelFort  2 роки тому

      Let me know where find it confusing
      email: info@excelfort.com
      If you are having a specific case then, I will have to have a look it

    • @lucianlackman8103
      @lucianlackman8103 2 роки тому

      @@ExcelFort how can you forget to state that in power bi desktop the buttons don’t work without control and click. All of teaching this stuff nobody said it. Someone just saved me tons of stress it was a very vital information. 🤦🏾‍♀️

  • @adafox4278
    @adafox4278 7 місяців тому

    Thank you so much for sharing. Great job!