Why Your Report Needs a BOX PLOT and How to Build It in Power BI
Ғылым және технология
In this video I go over all the steps to create a box plot visual in Power BI without having to rely on any custom visual. It captures key descriptive data that could reveal valuable insights into your data.
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
01:08 Visualizing statistics
08:52 Adding the box
11:17 Refining the formatting
15:58 Box Plot Variation
18:02 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 KZread: 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
Пікірлер: 149
Amazing creativity. Although this level of effort is just insane for something that should be standard in the PBI viz library. Histogram should also be part of the native viz library. MSFT made a mistake by relying too much on the idea of the “visualization marketplace”
Thank you for another amazing tutorial Bas. The timing of this was perfect for an ask I received! Your teaching style, personality and creativity are all incredible. It makes my morning when I see a notification showing a new video is posted. Thank you again!
Another great video. A couple small comments: 1. Perhaps you should also set up the minimum with a measure. That way your chart can also handle negative numbers. 2. I never noticed the sound effects before. Maybe I am just an old X-gen, but I find them distracting. Your videos have always been great without them. The old Mies' saying of "Less is more" might be applicable here. Having said that, I love your videos. By far the best PBI channel in KZread.
By far the best content about Power BI in KZread. Congratulations, Bas!
You never cease to amaze! As soon as I saw it I knew you were going to use a combo chart. It's the measures that were giving me fits! Thank you for posting this.
Awesome, it's just beautiful and the best, using native visuals. Bas, thank you very much for this video and for all your videos. I hope one day I can subscribe to at least one of your courses.
Thank you so much for this ingenious approach! I’ve been wanting to do box plots in PBI for so long, but could never use a custom visual due to IT restrictions 😢 - This will be a major enhancement in my analyses 🤸🏻♂️
One more jaw breaker video on PBI visuals. Thanks Bass.
@mneama4383
8 ай бұрын
I am really speechless i swear ❤
I always thought about it so thanks a lot for sharing!!!
It's Incredible! Good Job and Thank you! 🎉
Perfect timing with my work 😅Thank you Bas!
This was so fun and enligthing to recreate...Thank you so much.
Bas might not be pregnant but never failed to deliver best Power BI content.
@HowtoPowerBI
8 ай бұрын
last time I checked I wasn't pregnant lol :p very confused though .. thx ;)
top content as usual, new, fresh and thought through. thanks for doing this.
So many fancy video effects! And the box plot sound amazing!! Just starting the video!
Wow, what an ace in the pocket solution! Thank you!
Simply the best! No one else on KZread does PBI as well as you. Just looking at the way your work and layout your metrics helps me level up. Thank you so much. P.S. if you're selling mugs I would deffo buy one
@HowtoPowerBI
8 ай бұрын
THANK YOU!! 😁 I used to have some merch - nobody wanted it though 😂
@timothygallagher843
7 ай бұрын
@@HowtoPowerBI I learn so much from you I would wear underwear with your name stamped on it.
This is art!.Thanks for sharing your wisdom with us!
@HowtoPowerBI
8 ай бұрын
Glad you enjoyed it! 😊
Thank you very much. This is a very good idea.
Just Amazing Bas!, thanks for such valuable video.
Thank you, Bas! Your work makes mine shine :)
@HowtoPowerBI
8 ай бұрын
Happy to hear that thanks for the support
increadible workshop.... you're my man.👋👋👋
Amazing, great stuff!
Great video, I would also add another filter/slicer for the different categories alongside the date slicer. That way I also get the option select for which category to view the change in distribution over time (e.g. 2018-2020)
Great and very useful. Thanks a lot Bass
Just brilliant. Don't stop Bass! ❤
Great video Bas. For financials or inventory where you have an opening and closing balance, you'd probably want to have the IQR/bar colours indicate how the opening and closing balances compare, e.g. Open > Close = red (value decreased) or Close > Open = green (value increased). Not sure how I can do that as there is no fx conditional format for the bar colours.
master BAS, thank you for sharing
That was so impressive 🎉
Another amazing tutorial Thanks for sharing 🎉
@HowtoPowerBI
8 ай бұрын
😎👊
You sir are a genius
you are amazing my bro
Excelente! Parabéns!
Hello. I followed your instructions, and it really helped me a lot. I would like to ask how to incorporate outliers in the box plot
You are the best!
Magical, this one takes creativity to a new master level
@HowtoPowerBI
3 ай бұрын
thanks a lot! with the 100% overlap feature that was added to column/bar charts, there is now an easier approach however ( see the video 1 Trick for Endless Power BI Charts! )
Thank you very much! That's brilliant and simple simultaneously! I just have one question - is it possible to add the outliers to this box-whisker plot?
I've been trying to find exactly that for years! Thank you soooo much. I'm subscribing from today ! :)
@HowtoPowerBI
4 ай бұрын
Thanks for subbing!
You are the great ❤
I take off the hat, talent everywhere, behind the scene maybe took his time, thanks for your time to do and share.
very impressive Sir
You are the best. God sent. In isiZulu slang "uyi ghost". The equivalence to GOAT.
Amazing!!!
Awesome work! Do you know if there is a way to get logarithmic scale to work? Seems to be greyed out when I follow this tutorial. My datasets contain a few massive outliers (resolution time for support tickets) and the max values always make the box illegible. If I reduce axis scale to just contain the box I lose the changes in max value. Any ideas?
What a video.legend !!
Amazing work around! I am wondering if there is coming video to show work around Scatter Plot / Bubble Chart showing creative ideas and working around adding dynamic customised labels to it?
Thank you Bas for the great video. I have a challenge, while applying any slicer/filter/page interactive filter the error bars go to max data point irrespective of filters. Any help would be greatly appreciated!
Thank you! Just tried to create box plot for my report and it works perfectly! But, what if I have dataset with either positive and negative values? Can I somehow create box plot for these values too?
Amaaaazing ❤
This is legend @Bas! Can you share a link of your pbix file? I would like to see your measures as well...
Awesome video. Please share your measure dax.
Awesome Bas 💪😁
Or if you only need in desktop, then R visual (with limitations) is quick and easy :) Another awesome solution here from Bas! Is there anything he can't visualise? I think not.
Very clever 😎😎
This is excellent, thank you. Is it possible to flip 90 degrees & make it a horizontal box plot?
@HowtoPowerBI
7 ай бұрын
you are more limited when trying this technique for building it horizontally. This is because the error bars feature will disappear as soon as you have 2 or more series on the chart.
Please Sir, teach us to make Quartiles in measures to cotegorized others measures
Amazinggggg
Thanks! (again!). Is there anyway of making these plots horizontal please?
@HowtoPowerBI
4 ай бұрын
now with the feb 2024 release you can (100% overlap of columns became available).
Do you need to make all the corrections to the secondary y-axis? I find, that if I turn on the secondary y-axis and then turn it off again, all the datapoints get related to the primary y-axis.
Top!🎉
Maybe stupid question here, but how you calculate 25% percentile or 75% percentiles? There are no built in DAX formula for those? (like median() ). Thanks Bas, great content
@et2406
8 ай бұрын
PERCENTILE.EXC(column, kth percentile) or PERCENTILE.INC(column, kth percentile) as DAX formula with k between 0 and 1 (the 0th and 100th percentile). In the EXC version the data excludes both lower and upper bounds, while INC includes them.
@DionVansevenant
3 ай бұрын
@@et2406 So for this tutorial, are we using INC or EXC ? I'm trying EXC at this point: Sales Quantity PERCENTILE 75 = PERCENTILE.EXC(Invoiced[TotalDollars],0.75)
Thank you very much for the video, i have a question actually. Why do you set 0 and 30 as minimum and maximum of the axis? im actually doing a box and whiskers plot about temperatures of some refrigerators chambers and i need to understand why you set that limits on the Y axis.
@user-wz1cg2hi6w
7 ай бұрын
I am using data that also includes the negative axis, that is why I want to understand the logic of how I designate the minimum and maximum of the y axis.
Hi Master, thanks for the education! Anw, may I know how to rename with blank space when the data is Date Hierarchy? Any advice would be appreciated!🙏
@HowtoPowerBI
8 ай бұрын
I think you would need to drag in the year, quarter seperately instead of using the hierarchy
@imxltf
8 ай бұрын
@@HowtoPowerBI I see, lemme try tomorrow Master, thanks for the advice! 🫡🙏
If my dashboard background is dark, how to set tup, the Q1(25%) columns bar how to set transparent?
Bas, could you do a tutorial on using Python in PowerBI? Especially for the Python quick coding of visuals using the Seaborn visuals?
Hi there, this is a great video and has helped me quite a lot. My data has outliers in it, we can't find and plot the outliers through this approach? Can you help me with this?
@DanishMehra-hf4ux
27 күн бұрын
Usually there are points over the max which shows outlier values. Is there a way we can plot those?
@HowtoPowerBI
23 күн бұрын
points that are higher than the max? 😅 .. here is an easier way to achieve a boxplot kzread.info/dash/bejne/iZOjuZhxhJyeeag.html
Another brilliant video, Bas! Unfortunately, the link to download the file doesn't appear to work :(
@HowtoPowerBI
2 ай бұрын
oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video kzread.info/dash/bejne/iZOjuZhxhJyeeag.html
Thanks for the video! The download link to the pbix seems broken.
@HowtoPowerBI
2 ай бұрын
oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video kzread.info/dash/bejne/iZOjuZhxhJyeeag.html
wow 🤩🤩🤩
@HowtoPowerBI
8 ай бұрын
😎👊
Hi Bas, Do you know how we can use image as the Data Label for the chart? I created a measure with my img url and set the Data Category as Image URL but still shows me the URL in the data label and not showing the image
@HowtoPowerBI
8 ай бұрын
i don't think labels can show normal images.. the most you can do is unichar icons
@Neg-Power
8 ай бұрын
Thanks but With my case I wanted to show Countries Flag on each data point so I cannot use unichar icons@@HowtoPowerBI
Can we show the outliers using this technique?
Ohhh Microsoft :( always makes things with way too many steps. As a Data Analyst, give me the visual and the insights in the quickest way possible, and make the boxplot visual available for us so that we dont spend hours building one simple thing. At this point might use python... Appreciate you for doing the great video thought!
I have a challenge for you Bas. How can you restrict specific sheets for a specific user, when you publish a report to the power bi service? We know it can't be done using RLS or any other option available, so far. So... it´s up to you.
@HowtoPowerBI
8 ай бұрын
there are already many couple of blogs / vids on this - I dont have so much to add on the topic (for example kzread.info/dash/bejne/q5louauDdMnKoLw.html)
mitico!
@HowtoPowerBI
8 ай бұрын
thanks! 😊
How do you make the colours different for each box if they are on the same chart?
@HowtoPowerBI
3 ай бұрын
with the latest updates in Power BI you can achieve the chart in an easier way kzread.info/dash/bejne/iZOjuZhxhJyeeag.html .. then you can just drop a field on legend
First of all, a big thank you, a great tutorial! Really a visually appealing solution, but unfortunately with two disadvantages: As soon as negative values come into play, the view is destroyed, and unfortunately, you can't recognize the outliers, such as according to John W. Tukey. Do you have any idea how we can catch that?
@HowtoPowerBI
8 ай бұрын
thank you ! 😊 I don't really get the point though. Outliers are captured in the range (max min) and I don't see why negative values destroy the view? could you elaborate a bit more
@jackbeauregard7041
8 ай бұрын
@@HowtoPowerBI Of course, no problem: Change your dataset to include negative values (e.g., -100, -90, ... 0 ... 90, 100) and remove the limits on the X-axis. Then you need to look at the boxes of the bar chart: The order of the boxes will be changed. Until now, you had the first box above the X-axis in white, then followed the two blue boxes for the quartiles. In my example above, the median is 0. The second quartile ranges from -50 to 0, the third from 0 to 50. However, your first quartile is reported at -50 and therefore represents the range from -50 to 0 in white. The boxes are incorrectly built upon each other. The minimum and maximum are correct, the metrics too. It's just the representation of the boxes that is wrong. Could you understand it this way?
@matthiaseilenbrock
8 ай бұрын
@jackbeauregard7041 is correct, one must depict various scenarios since the boxes can be completely negative, partially negative, or only positive. Therefore, in the German financial administration, we have been using a box plot that takes the respective scenarios into account for quite some time, following the principle shown in the video. Our auditors can integrate this into any pbix file by adjusting the metrics and copying the code. We also do not have a solution for the real outliers in the often typical representation of the box plot with whiskers that are 1.5×IQR in length. I would be interested in an idea for that as well. But a great video, always a huge inspiration for us!
@jackbeauregard7041
8 ай бұрын
@@matthiaseilenbrock Cool, I suppose these are internal matters that you're not allowed to share, right?
@matthiaseilenbrock
8 ай бұрын
@@jackbeauregard7041 Exactly, unfortunately, I can't say more about it. But ultimately, the idea from the video just needs to be applied to the other conceivable constellations.
Could you add data labels to this?
@HowtoPowerBI
4 ай бұрын
Yes you could.. with the feb 24 update you could also approach like here 1 Trick for Endless Power BI Charts! kzread.info/dash/bejne/iZOjuZhxhJyeeag.html
Takk!
@HowtoPowerBI
8 ай бұрын
Thank you for the support:)
how to integrate the data points in the box plot
how did you make the measures?
@HowtoPowerBI
4 ай бұрын
you can download the file from the description then you can see the measures
I have a problem with the error bars it doesn't work for me When I put the max and min and enable it, it doesn't appear
How can we add dots for data points like scatter
@arunwats
16 күн бұрын
Any help in this please?
The IQR is screwed if your data range from negative to positive. My current workaround is using error band on the median. This solution is unfortunately very situational :(
@HowtoPowerBI
2 ай бұрын
You can use the approach in this video 1 Trick for Endless Power BI Charts! kzread.info/dash/bejne/iZOjuZhxhJyeeag.html
*Reinventing out-of-the-box thinking.*
I do not see the error bars option? How can this be fixed?
@HowtoPowerBI
4 ай бұрын
power bi has a "new" on object editing option under preview. Turn it on and the formatting pane will looks the same. You can also leave it as you have and click on the analytics tab (right from formatting)
The link to the file is not found. You get 404 error
Lol, I cannot keep up with all the updates. I am very curious what you will make of updates that are coming on the native visuals in November and December.
no error bar option
@HowtoPowerBI
4 ай бұрын
Turn onobject on under preview. Or look in the analytics tab
🤯
How come everyone seems to see the 'Error bar' option but me?
@alicedwonderland7733
8 ай бұрын
I also download the PBI file from your site and I can't see it in there neither... What sorcery is this? Update: I need to turn on the Preview feature 'on object interaction' :)
@HowtoPowerBI
8 ай бұрын
😁 happy you found it.. but the error bars are also there without on object interaction (you have to click on the "analytics tab" (next to the formatting btn) )
@alicedwonderland7733
8 ай бұрын
@@HowtoPowerBI Oh WOW! It is there!!! I'm going back to the non-object interaction WHILE keeping this awesome visual! Bas, amazing as always!!
I have no idea why my power bi is not showing ERROR BARS
Bas, first time I disagree with you. A Box Plot is necessary to a Fisrt glance to see if the data is correlated. This correlation is not going to change over time in normal circumstances, which means that the plot is never going to change. And a decision maker would never use it to make a decision. Great content as usual, but I think that the plot itself is not that important for business purposes.
@HowtoPowerBI
8 ай бұрын
a box plot has nothing to do with correlation... i think you might be mixing some things up here
You have a visual names box plots in power bi don't need tu do all this (save time).
nah was of time
The average person doesn't know enough about statistics or percentiles to understand box plots unfortunately, so I think most of the effort put into this would be wasted for most roles. Not saying there aren't any good uses for them, but i've been a data analyst for 5 years and have never needed them.
HI Guys, I do not seem to have the spacing option for formatting the columns :( Anyone know how to make it visible?
@HowtoPowerBI
4 ай бұрын
latest version? preview options on-object editing turned on? .. I probably would create the boxplot differently now with the feb 2024 update. You can use overlap, 100%, and then make use of error bars (video coming out tomorrow on this topic)
@jacveragmail
4 ай бұрын
Yes, I am using the Feb 24 version. I will wait for the video. Thanks :)@@HowtoPowerBI
Amazing !!!
@HowtoPowerBI
8 ай бұрын
😊😎