100% Axis CONTROL in Power BI
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- Take 100% control of your axis! The scale you choose has a big impact on your visualizations. In this video I show you how to create a toggle button to switch between auto scaling and manual scaling with the option to have synced scales between charts. Additionally we'll build a zoom slider for the axis scale to enable users to enlarge fluctations (zoom in) when necessary.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:47 Why would you want more axis control?
02:09 Creating a synced zoom slider
04:49 Creating a toggle button to switch between auto and manual scaling
08:13 Disable the range slider when auto is selected
10:00 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on TH-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - วิทยาศาสตร์และเทคโนโลยี
![ตีสิบเดย์ [FULL] | คู่รักแซฟฟิก "หลิงหลิง-ออม" จากซีรีย์ "ใจซ่อนรัก"](http://i.ytimg.com/vi/zs8AfphGn2w/mqdefault.jpg)
![The Wall Song ร้องข้ามกำแพง | EP.202 | ตั้ม วราวุธ / เบสท์ คำสิงห์ | 18 ก.ค. 67 [1/5]](http://i.ytimg.com/vi/cwIoA7XHqnE/mqdefault.jpg)
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powerbidesigntransformation
Bas never disappoints. This is a brilliant one. The last trick on disabling a slicer is brilliant.
Your Power BI tutorial have been instrumental in helping me grasp the nuances of range management and fluctuation visualization. I'm truly impressed by the depth and clarity of your explanations. Keep inspiring us with your valuable content!
The slicer disabling trick is just ... 🤯
Thanks, Bas!
Just want to thank you for all your videos. So helpful
Another golden video, keep the great content coming. Love this tip!
you always come up with special things, thanks for sharing BAS
Great tutorial, this is exactly what i need! Thank you!
Suuper, i have to give it a try on my own reports 😊
Thanks for the inspirational vids.
Huge fan of your lessons
Wow thank you for sharing, this is what I looking for 🤩
Bas is my hero. Thanks again for sharing
Great video. Just what I was looking for!
Hello Bas, thank you. Maybe for this video you also could mention the "Zoom Slider" that is an option in the Format pane. I just tried your solution and the build in zoom sliders. They work side by side, but I think it very confusing. Besides: the manual slicer seems to influence the build in slicer but not the other way.
Well explained. Thank you Bass
Learned something new that how can we disable filter based on another filter
Thanks Boss
Nice trick.. thank you
Needed this too. I’m in process of how to switch horizontal stacked bar chart numeric values to display text. So rather than the numeric value display…show a category name on the bar 🤔☺️
Brilliant video and step by step explanation!
Thank you Bas!🙇♂
An excelent tutorial, thank you sir.
You are just brilliant
Hello Bas, this is great! Thank you so much for this
I have a question popped out, do you know how to control tick density for "Line and clustered column" chart?
e.g., for a chart that has y-axis default tick as following: 0M, 2M, 4M, ..., 12M (increment by 2),
I want to increase the density by having it increment by 1, so it will be 0M, 1M, 2M, 3M, and so on.
Thank you
Wow, so cool! Thanks!!!
You are a genius!
High level, Bas!
Hey Bas, just found your channel and I love the presentation. I've been just using Tableau for about 7 years now and am just starting to learn PBI. Have a question for you...
Could you show the PBI version of collapsible containers? IE - I click on something in a view, and that collapses the view I clicked on and brings up another view, and then if I click again I'm back to the view I first clicked on?
Example use case: Bar chart showing total sales by segment. Clicking on a segment will show a list of all transactions for the last 7 days.
Likewise, thank you for showing. :-)
Is there a way to do SCALE BREAK. We often have graph where one or two entries are off scale and break our reporting (ex: sales spikes in a specific period). What technique would you recommend to deal with such a situation? Oh and Log scale does not work for us...we really need to find a scale break solution.
i am currently working on Power BI RS and getting difficulty to make a viusal full screen in client system, i am trying ?rs:Command=Render&rc:Toolbar=false in url so that i can show full screen but it is not working. please guide me
Thanks you!
Hi Bas, thanks for the video, is there a way to fix the Y axis interval like 0, 5, 10, 15.....Millions rather than depending on Power BI automatic way
Fixing the min and maximum is what you are showing but just want to know is there way we can decide the internal step(intervals)
hello bass, thank you.
Really cool idea...but wouldn't it be better to use Bookmarks to hide the manual element when auto is selected?
I thought that he was going to tackle it that way, but I like the approach of using filters better since bookmarks are such a pain to manage as things on the report get changed.
Bookmarks are a real PITA to manage though. This way is much better imo.
Bas - Great as always. And ahead of your time as you beat Microsoft to this by a day it seems! The November update seems to solve the issue discussed here.
Haha yes and no… it still doesn’t let the user decide what to see. It lets the developer decide
How does the measure to disable the slicer actually working
with the measure "Range disable" indicated to display the values only if the option "Manual" was selected, that is, for 1. Otherwise, no data is passed to the sclier, so it displays nothing.
@@jakubskotarek7792 Thanks Johhny 👍