Your'e awesome man and that new bookmark feature has just opened a new world of visual tricks in my whacky world of graphs - I will create hallucinations lol
@NPT6 жыл бұрын
Eddy Jawed you’re welcome, love the comments!
@sonetmollick46303 жыл бұрын
Thank you so much. That was quite useful. I have implemented this technique today in my report.
@NPT3 жыл бұрын
You're welcome Sonet. 👍
@BIMoji16 жыл бұрын
Very nice video. It's really helpful. I dont know why people dislike educational videos.
@NPT6 жыл бұрын
Thanks Vidya. Much appreciated.
@christianlira12595 жыл бұрын
Hi Nathan. I was looking for another alteryx to PBI feature video and came across this toggle video...which now serves me for another purpose. Brilliant!...I like your logical presentations, and thank you.
@ADITYA12345883 жыл бұрын
Great video Nathan! It is very useful and takes the report to next level. Kudos👍
@NPT2 жыл бұрын
Glad it was helpful!
@ammarsn724 жыл бұрын
Hi Nathan. This is super useful and thank you for all the great work you share...appreciated.
@NPT4 жыл бұрын
Thanks for the kind words Ammar! Glad the video is useful.
@premj824 жыл бұрын
Thank you so much for the video, it helped me understand the concept of bookmarks
@NPT2 жыл бұрын
I'm glad it helped, Prem! 👍
@satheeshkumar91013 жыл бұрын
Excellent and very clear explanation. Thank you :)
@NPT2 жыл бұрын
Glad it was helpful!
@info2satish6 жыл бұрын
Awesome Patrick, just one feedback - pls try using zoom in/out feature for videos, as it does not appear clear when on whole screen view. Awesome man!!👍
@NPT6 жыл бұрын
Thanks Satish. I'll be sure to use the zoom and pan on the upcoming videos. I've got a few up now that use that feature.
@meterypsy6 жыл бұрын
What a neat trick! Thanks a lot for sharing!
@NPT6 жыл бұрын
meterypsy you’re welcome. Thanks for the sub! 😀
@abeggmi4 жыл бұрын
Great presentation of a perfect workaround - I would wish MS to present such a feature "out of the box" ;-) - But in the end it's not my fault if people get used to iOS-Buttons in a MS Software ;-)
@loganathannainar48045 жыл бұрын
Wonderful explanation!!!
@andrestricker41183 жыл бұрын
13:57 was there no data because the hidden slicer was still active, only showing the last 4 years?
@shoeb13594 жыл бұрын
Crisp and clear Explanation. Good Job Patrick. Any idea or suggestion for Alteryx beginner course .
@balashenbak61683 жыл бұрын
Thanks a ton Brother!
@NPT3 жыл бұрын
Any time!
@genkwan14 жыл бұрын
Well done. Thanks for helping
@NPT3 жыл бұрын
No problem 👍
6 жыл бұрын
Thank you for the clear guidance and cool tip! Is it possible that the toggle button only functions in reports only and it does not work on dashboards?
@NPT6 жыл бұрын
Hi Andras, you are correct. I just created a test dashboard containing a toggle button and the toggle does not switch when clicked. My personal take on Dashboards vs. Reports in Power BI is that Dashboards are visuals only and the real functionality is seen in Reports. That's the feeling I get when I interact which each type of object in the Power Bi service.
@eddyjawed48716 жыл бұрын
I owe you a pint of lager or beer if you ever visit Manchester, England :)
@NPT6 жыл бұрын
Ha! Eddy Jawed, I will hold you to it buddy! 😁
@jbyxxx5 жыл бұрын
Great explanation, thank you :)
@kernelab4 жыл бұрын
Is there any way to preserve your slicer values when toggling I set this up and the filters keep resetting. Thanks
@NPT3 жыл бұрын
Yes, one the ellipses (...) menu you can specify which object the bookmark applies to (all vs. selected) so it doesn't change your slicers.
@TheSoumya113 жыл бұрын
Thanks :)
@NPT2 жыл бұрын
You're welcome! 👍
@muneeriqbal72044 жыл бұрын
Guys can anyone telll if these buttons work without pressing cltr button. I activated some buttons and setup bookmarks but it only works with ctrl plus click
@NPT4 жыл бұрын
Hi there Muneer, you only have to hold the CTRL key down in the Power BI Desktop app while in development. Once you publish the report to the Power BI Service, the button works like any other button using left-click.
@muneeriqbal72044 жыл бұрын
@@NPT Thanks man for the info. Appreciated
@joseguilhermearita99906 жыл бұрын
Thanks for the info! Does Bookmarking works on Dashboards?
@NPT6 жыл бұрын
Hi Jose, I just pinned a live page to a dashboard and it appears that the bookmarking feature does not work on dashboards. So that an unhappy face :-( from me. There is an Idea out on the Power BI community site for this item. You can vote on it here: ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31942489-bookmarks-on-bi-service-at-dashboard-level ~ Nathan
@joseguilhermearita99906 жыл бұрын
Thank you again Nathan... I will be certainly voting for.
@smartyhassan4 жыл бұрын
HI Patrick, can a bookmark save status across pages in power bi ? One Bookmark change visuals across pages ?
@NPT3 жыл бұрын
Yes, I think so. you may have to combine it with the Sync Slicers feature.
@JohnOttoKnoke6 жыл бұрын
Hi, your videos are great! Can you point me out to where I can download the Adventure Works db?
@NPT6 жыл бұрын
Hi John, you can download the AdventureWorks database here: www.microsoft.com/en-us/download/details.aspx?id=49502
@medtaherbouzid90546 жыл бұрын
Hi Nathan , nice video but I want to ask you if can we link this toogle button to a function for example export chart ?
@NPT6 жыл бұрын
Great question Med, let me do a little digging and I'll let you know what I turn up.
@medtaherbouzid90546 жыл бұрын
Nathan Patrick Taylor Okay Nathan thank you It is awfully nice of you
@NPT6 жыл бұрын
Not a problem. I'm just as curious as you are. If it is not possible, it should be added to the feature list.
@medtaherbouzid90546 жыл бұрын
Nathan Patrick Taylor Hh yes sure :) But I think if it is not possible we can go through developing a custom visual to have property/ function export the chart ....
@medtaherbouzid90546 жыл бұрын
So Nathan , do you find a solution ?
@dibakarroy38536 жыл бұрын
Nice Trick. Thanks.
@NPT6 жыл бұрын
Thanks Dibakar!
@gopid63426 жыл бұрын
i can't have the "Link" option in Format image when i select the image button, what can i do to show the "Link" option in format image ??????
@asthajain24 жыл бұрын
Gopi D if you do not have link button, select the option : turn on action
@aparajith11596 жыл бұрын
********** Need HELP ********** Can't get this to work properly. When I set the Relative ON to say 4/1/17 - 5/1/18 and then toggle to the Relative OFF state and use the between slider to select 1/1/17 - 3/1/17 (which is out of the original range), then the data still shows 4/1/17 - 5/1/18 because the relative slicer is still active although its not visible. The two slicers are not acting independent of each other in their respective state. How can we fix this?
@NPT6 жыл бұрын
Hi Aparajith, it sounds like you need to use the features found in the "Bookmarks Pane" which allow you to choose how a bookmark is updated and modified in relation to other objects on the report. I created a separate video highlighting these features. You can watch it here: kzfaq.info/get/bejne/jt6Emsml0rWxdas.html
6 жыл бұрын
Hi Aparajith, I had the same problem and I fixed it by setting a super long time frame for the relative slicer when editing the bookmark for the Relative OFF... let said the last 100 years. Hope it helps.
@aparajith11596 жыл бұрын
By doing that, your relative filter state would show too many months for data which is not desirable because in my case, that is the default view of the page when the report loads. It has to be defaulted to last 13 months at load time (Relative ON) and then let the user toggle to RelativeOFF state if he wishes.
@sssylk6 жыл бұрын
Hi have you figured this out? I am running into the exact same issue and the video to choose the bookmark updated and modified option solution didn't work for me.
@aparajith11596 жыл бұрын
Nope. None of the replies or the videos helped me. I had to remove the toggle functionality and just go with one relative filter.
@tarassamolyuk16594 жыл бұрын
Hi , where can down load /get toggle button?
@NPT3 жыл бұрын
It is a custom made button image (it is not actually a button). Some search for any toggle image online and chose two (on/off) that you like.
@maheshbabukoppolu30334 жыл бұрын
how to uncheck the radio buttons or how to clear the radio buttons
@NPT3 жыл бұрын
You'll need to place each button in the desired state and then save it as a bookmark.
@mohammedALI36 жыл бұрын
thanks, can you tell me how I can design report with nivagation between more than one graph and report, and how design tabs with specific name and if the user click on any tab must be show specific section in the report
@NPT6 жыл бұрын
Hi Mohammed, for multiple tabs, you can use the drill through feature to allow users to drill through to more than one report tab (or chart). I've done a video on drill through here: kzfaq.info/get/bejne/jsddZ82kx7GyoGw.html Check it out and if that doesn't have what you need I can put together a specific video for multi-tab connections.
@mohammedALI36 жыл бұрын
+Nathan Patrick Taylor grate, I would like to thank you for your reply, I will check the link video and give you feedback about this, kindly drop you email here to keep in touch. regards,
@mohammedALI36 жыл бұрын
Hi Nathan, please help me When getting data from SQL DB, it prompts "The data source you're trying to access doesn't support encryption. To access this data source using an unencrypted connection, click OK".". What does this message mean?
@NPT6 жыл бұрын
Hi Mohammed, here's the best answer I can give on that error... the message is simply a warning about the way that Power BI Desktop is connecting to your data source. For me, I'm connecting from my local PC to an on-premise server that is not accesbile from the Internet. So the warning is not a big deal. When I publish my report to the Power BI service, it uses the Enterprise Gateway, which is secure. The only issue I can see is if you are connecting to a data source that is on a public cloud platform. In that case, the credentials could potentially be seen by others when switching to a non-encrypted connection. I hope that makes sense. Here's a good blog post on the topic: blog.pragmaticworks.com/power-bi-and-data-security-compliance-and-encryption
@mohammedALI36 жыл бұрын
Thanks A lot, can you tell me how I can write notes or comment on power bi dashboard for For explanation