Why Your Report Needs a BOX PLOT and How to Build It in Power BI
Vložit
- čas přidán 4. 07. 2024
- 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 CZcams: 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 - Věda a technologie
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 CZcams.
By far the best content about Power BI in CZcams. Congratulations, Bas!
One more jaw breaker video on PBI visuals. Thanks Bass.
I am really speechless i swear ❤
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.
Bas might not be pregnant but never failed to deliver best Power BI content.
last time I checked I wasn't pregnant lol :p very confused though .. thx ;)
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 🤸🏻♂️
Perfect timing with my work 😅Thank you Bas!
So many fancy video effects! And the box plot sound amazing!! Just starting the video!
I always thought about it so thanks a lot for sharing!!!
This was so fun and enligthing to recreate...Thank you so much.
It's Incredible! Good Job and Thank you! 🎉
top content as usual, new, fresh and thought through. thanks for doing this.
Wow, what an ace in the pocket solution! Thank you!
Simply the best! No one else on CZcams 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
THANK YOU!! 😁 I used to have some merch - nobody wanted it though 😂
@@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!
Glad you enjoyed it! 😊
Thank you, Bas! Your work makes mine shine :)
Happy to hear that thanks for the support
Just Amazing Bas!, thanks for such valuable video.
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)
increadible workshop.... you're my man.👋👋👋
Thank you very much. This is a very good idea.
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.
Great and very useful. Thanks a lot Bass
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
I've been trying to find exactly that for years! Thank you soooo much. I'm subscribing from today ! :)
Thanks for subbing!
Another amazing tutorial
Thanks for sharing 🎉
😎👊
Just brilliant. Don't stop Bass! ❤
Magical, this one takes creativity to a new master level
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?
Amazing, great stuff!
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?
master BAS, thank you for sharing
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?
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?
That was so impressive 🎉
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!
Excelente! Parabéns!
I take off the hat, talent everywhere, behind the scene maybe took his time, thanks for your time to do and share.
You sir are a genius
you are amazing my bro
You are the best!
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
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.
@@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)
What a video.legend !!
You are the great ❤
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.
This is excellent, thank you. Is it possible to flip 90 degrees & make it a horizontal box plot?
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.
Amazing!!!
This is legend @Bas! Can you share a link of your pbix file? I would like to see your measures as well...
Amaaaazing ❤
You are the best. God sent. In isiZulu slang "uyi ghost". The equivalence to GOAT.
Awesome video. Please share your measure dax.
Please Sir, teach us to make Quartiles in measures to cotegorized others measures
very impressive Sir
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.
Thanks! (again!). Is there anyway of making these plots horizontal please?
now with the feb 2024 release you can (100% overlap of columns became available).
Awesome Bas 💪😁
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!🙏
I think you would need to drag in the year, quarter seperately instead of using the hierarchy
@@HowtoPowerBI I see, lemme try tomorrow Master, thanks for the advice! 🫡🙏
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.
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.
If my dashboard background is dark, how to set tup, the Q1(25%) columns bar how to set transparent?
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?
Usually there are points over the max which shows outlier values. Is there a way we can plot those?
points that are higher than the max? 😅 .. here is an easier way to achieve a boxplot czcams.com/video/W_oW68T98IE/video.html
Very clever 😎😎
Amazinggggg
Bas, could you do a tutorial on using Python in PowerBI? Especially for the Python quick coding of visuals using the Seaborn visuals?
Top!🎉
Another brilliant video, Bas! Unfortunately, the link to download the file doesn't appear to work :(
oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video czcams.com/video/W_oW68T98IE/video.html
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
i don't think labels can show normal images.. the most you can do is unichar icons
Thanks but With my case I wanted to show Countries Flag on each data point so I cannot use unichar icons@@HowtoPowerBI
Thanks for the video! The download link to the pbix seems broken.
oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video czcams.com/video/W_oW68T98IE/video.html
Can we show the outliers using this technique?
wow 🤩🤩🤩
😎👊
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!
How do you make the colours different for each box if they are on the same chart?
with the latest updates in Power BI you can achieve the chart in an easier way czcams.com/video/W_oW68T98IE/video.html .. then you can just drop a field on legend
mitico!
thanks! 😊
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?
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
@@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?
@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!
@@matthiaseilenbrock Cool, I suppose these are internal matters that you're not allowed to share, right?
@@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.
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
Could you add data labels to this?
Yes you could.. with the feb 24 update you could also approach like here 1 Trick for Endless Power BI Charts!
czcams.com/video/W_oW68T98IE/video.html
how did you make the measures?
you can download the file from the description then you can see the measures
how to integrate the data points in the box plot
Takk!
Thank you for the support:)
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.
there are already many couple of blogs / vids on this - I dont have so much to add on the topic (for example czcams.com/video/ye4WIJDfdpY/video.html)
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 :(
You can use the approach in this video 1 Trick for Endless Power BI Charts!
czcams.com/video/W_oW68T98IE/video.html
*Reinventing out-of-the-box thinking.*
How can we add dots for data points like scatter
Any help in this please?
I do not see the error bars option? How can this be fixed?
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
Turn onobject on under preview. Or look in the analytics tab
How come everyone seems to see the 'Error bar' option but me?
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' :)
😁 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) )
@@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.
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).
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.
nah was of time
HI Guys, I do not seem to have the spacing option for formatting the columns :(
Anyone know how to make it visible?
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)
Yes, I am using the Feb 24 version. I will wait for the video. Thanks :)@@HowtoPowerBI
Amazing !!!
😊😎