Power BI - Toggle Button and Bookmarks

  Рет қаралды 59,905

Nathan Patrick Taylor

Nathan Patrick Taylor

Күн бұрын

Пікірлер: 77
@eddyjawed4871
@eddyjawed4871 6 жыл бұрын
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
@NPT
@NPT 6 жыл бұрын
Eddy Jawed you’re welcome, love the comments!
@sonetmollick4630
@sonetmollick4630 3 жыл бұрын
Thank you so much. That was quite useful. I have implemented this technique today in my report.
@NPT
@NPT 3 жыл бұрын
You're welcome Sonet. 👍
@BIMoji1
@BIMoji1 6 жыл бұрын
Very nice video. It's really helpful. I dont know why people dislike educational videos.
@NPT
@NPT 6 жыл бұрын
Thanks Vidya. Much appreciated.
@christianlira1259
@christianlira1259 5 жыл бұрын
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.
@ADITYA1234588
@ADITYA1234588 3 жыл бұрын
Great video Nathan! It is very useful and takes the report to next level. Kudos👍
@NPT
@NPT 2 жыл бұрын
Glad it was helpful!
@ammarsn72
@ammarsn72 4 жыл бұрын
Hi Nathan. This is super useful and thank you for all the great work you share...appreciated.
@NPT
@NPT 4 жыл бұрын
Thanks for the kind words Ammar! Glad the video is useful.
@premj82
@premj82 4 жыл бұрын
Thank you so much for the video, it helped me understand the concept of bookmarks
@NPT
@NPT 2 жыл бұрын
I'm glad it helped, Prem! 👍
@satheeshkumar9101
@satheeshkumar9101 3 жыл бұрын
Excellent and very clear explanation. Thank you :)
@NPT
@NPT 2 жыл бұрын
Glad it was helpful!
@info2satish
@info2satish 6 жыл бұрын
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!!👍
@NPT
@NPT 6 жыл бұрын
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.
@meterypsy
@meterypsy 6 жыл бұрын
What a neat trick! Thanks a lot for sharing!
@NPT
@NPT 6 жыл бұрын
meterypsy you’re welcome. Thanks for the sub! 😀
@abeggmi
@abeggmi 4 жыл бұрын
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 ;-)
@loganathannainar4804
@loganathannainar4804 5 жыл бұрын
Wonderful explanation!!!
@andrestricker4118
@andrestricker4118 3 жыл бұрын
13:57 was there no data because the hidden slicer was still active, only showing the last 4 years?
@shoeb1359
@shoeb1359 4 жыл бұрын
Crisp and clear Explanation. Good Job Patrick. Any idea or suggestion for Alteryx beginner course .
@balashenbak6168
@balashenbak6168 3 жыл бұрын
Thanks a ton Brother!
@NPT
@NPT 3 жыл бұрын
Any time!
@genkwan1
@genkwan1 4 жыл бұрын
Well done. Thanks for helping
@NPT
@NPT 3 жыл бұрын
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?
@NPT
@NPT 6 жыл бұрын
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.
@eddyjawed4871
@eddyjawed4871 6 жыл бұрын
I owe you a pint of lager or beer if you ever visit Manchester, England :)
@NPT
@NPT 6 жыл бұрын
Ha! Eddy Jawed, I will hold you to it buddy! 😁
@jbyxxx
@jbyxxx 5 жыл бұрын
Great explanation, thank you :)
@kernelab
@kernelab 4 жыл бұрын
Is there any way to preserve your slicer values when toggling I set this up and the filters keep resetting. Thanks
@NPT
@NPT 3 жыл бұрын
Yes, one the ellipses (...) menu you can specify which object the bookmark applies to (all vs. selected) so it doesn't change your slicers.
@TheSoumya11
@TheSoumya11 3 жыл бұрын
Thanks :)
@NPT
@NPT 2 жыл бұрын
You're welcome! 👍
@muneeriqbal7204
@muneeriqbal7204 4 жыл бұрын
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
@NPT
@NPT 4 жыл бұрын
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.
@muneeriqbal7204
@muneeriqbal7204 4 жыл бұрын
@@NPT Thanks man for the info. Appreciated
@joseguilhermearita9990
@joseguilhermearita9990 6 жыл бұрын
Thanks for the info! Does Bookmarking works on Dashboards?
@NPT
@NPT 6 жыл бұрын
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
@joseguilhermearita9990
@joseguilhermearita9990 6 жыл бұрын
Thank you again Nathan... I will be certainly voting for.
@smartyhassan
@smartyhassan 4 жыл бұрын
HI Patrick, can a bookmark save status across pages in power bi ? One Bookmark change visuals across pages ?
@NPT
@NPT 3 жыл бұрын
Yes, I think so. you may have to combine it with the Sync Slicers feature.
@JohnOttoKnoke
@JohnOttoKnoke 6 жыл бұрын
Hi, your videos are great! Can you point me out to where I can download the Adventure Works db?
@NPT
@NPT 6 жыл бұрын
Hi John, you can download the AdventureWorks database here: www.microsoft.com/en-us/download/details.aspx?id=49502
@medtaherbouzid9054
@medtaherbouzid9054 6 жыл бұрын
Hi Nathan , nice video but I want to ask you if can we link this toogle button to a function for example export chart ?
@NPT
@NPT 6 жыл бұрын
Great question Med, let me do a little digging and I'll let you know what I turn up.
@medtaherbouzid9054
@medtaherbouzid9054 6 жыл бұрын
Nathan Patrick Taylor Okay Nathan thank you It is awfully nice of you
@NPT
@NPT 6 жыл бұрын
Not a problem. I'm just as curious as you are. If it is not possible, it should be added to the feature list.
@medtaherbouzid9054
@medtaherbouzid9054 6 жыл бұрын
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 ....
@medtaherbouzid9054
@medtaherbouzid9054 6 жыл бұрын
So Nathan , do you find a solution ?
@dibakarroy3853
@dibakarroy3853 6 жыл бұрын
Nice Trick. Thanks.
@NPT
@NPT 6 жыл бұрын
Thanks Dibakar!
@gopid6342
@gopid6342 6 жыл бұрын
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 ??????
@asthajain2
@asthajain2 4 жыл бұрын
Gopi D if you do not have link button, select the option : turn on action
@aparajith1159
@aparajith1159 6 жыл бұрын
********** 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?
@NPT
@NPT 6 жыл бұрын
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.
@aparajith1159
@aparajith1159 6 жыл бұрын
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.
@sssylk
@sssylk 6 жыл бұрын
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.
@aparajith1159
@aparajith1159 6 жыл бұрын
Nope. None of the replies or the videos helped me. I had to remove the toggle functionality and just go with one relative filter.
@tarassamolyuk1659
@tarassamolyuk1659 4 жыл бұрын
Hi , where can down load /get toggle button?
@NPT
@NPT 3 жыл бұрын
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.
@maheshbabukoppolu3033
@maheshbabukoppolu3033 4 жыл бұрын
how to uncheck the radio buttons or how to clear the radio buttons
@NPT
@NPT 3 жыл бұрын
You'll need to place each button in the desired state and then save it as a bookmark.
@mohammedALI3
@mohammedALI3 6 жыл бұрын
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
@NPT
@NPT 6 жыл бұрын
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.
@mohammedALI3
@mohammedALI3 6 жыл бұрын
+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,
@mohammedALI3
@mohammedALI3 6 жыл бұрын
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?
@NPT
@NPT 6 жыл бұрын
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
@mohammedALI3
@mohammedALI3 6 жыл бұрын
Thanks A lot, can you tell me how I can write notes or comment on power bi dashboard for For explanation
@RustemYeleussinov
@RustemYeleussinov 6 жыл бұрын
Thanks!
How to Publish Data from Alteryx to Power BI
9:01
Nathan Patrick Taylor
Рет қаралды 13 М.
Build a TOGGLE BUTTON Like a PRO in Power BI
14:06
How to Power BI
Рет қаралды 185 М.
Чёрная ДЫРА 🕳️ | WICSUR #shorts
00:49
Бискас
Рет қаралды 6 МЛН
白天使选错惹黑天使生气。#天使 #小丑女
00:31
天使夫妇
Рет қаралды 15 МЛН
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 54 МЛН
Mastering Power BI Bookmarks
12:05
Guy in a Cube
Рет қаралды 293 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 99 М.
Taking Buttons in Power BI Desktop to the Next Level
10:48
Guy in a Cube
Рет қаралды 401 М.
Power BI - Toggles, Bookmarks, and Sync Slicers
11:56
Nathan Patrick Taylor
Рет қаралды 16 М.
Transform your reports with INTERACTIVE buttons that SWITCH visuals
11:32
Power BI Bookmarks, Selections and Toggles
8:25
Guy in a Cube
Рет қаралды 373 М.
when foldable cellphones follow the trend#shorts
0:11
amazing populer
Рет қаралды 16 МЛН
iPhone 15 Plus на Изгибе
0:59
Sergey Delaisy
Рет қаралды 224 М.
Самый дорогой телефон 2000х
0:54
МАДНЕСС
Рет қаралды 2,6 МЛН