Why Your Report Needs a BOX PLOT and How to Build It in Power BI

[@juaneochoa]

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 KZbin.

[@pmo4325]

If Bas can build a Box Plot in under 20 mins using native visuals, why can't Microsoft build a native Box Plot visual in 9 years?

[@soggygoldfish]

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!

[@greenj0ke]

you just gained a new follower, great content, im amazed with your skill level!

[@sukoi2113]

One more jaw breaker video on PBI visuals. Thanks Bass.

[@mneama4383]

I am really speechless i swear ❤

[@kounelly835]

Perfect timing with my work 😅Thank you Bas!

[@dezcraft_dev]

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”

[@PildorasBI]

It's Incredible! Good Job and Thank you! 🎉

[@wojpaw5362]

Simply the best! No one else on KZbin 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]

THANK YOU!! 😁 I used to have some merch - nobody wanted it though 😂

[@timothygallagher843]

@@HowtoPowerBI I learn so much from you I would wear underwear with your name stamped on it.

[@WooS1986]

I always thought about it so thanks a lot for sharing!!!

[@geirberge8971]

Magical, this one takes creativity to a new master level

[@HowtoPowerBI]

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! )

[@alicedwonderland7733]

So many fancy video effects! And the box plot sound amazing!! Just starting the video!

[@esteban-alvino]

I take off the hat, talent everywhere, behind the scene maybe took his time, thanks for your time to do and share.

[@chrisgask]

Wow, what an ace in the pocket solution! Thank you!

[@siyabongamyeza47]

You are the best. God sent. In isiZulu slang "uyi ghost". The equivalence to GOAT.

[@AdsonJrChua]

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

[@bassamaboallaban]

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)

[@nataliatsvetkov9977]

Thank you, Bas! This is exactly what I was looking for! Your every video is amazing, every time I learn something new and useful!

[@jesserussell3192]

How did you get it to work? I'm missing several of the options that are shown in the video for PowerBI. Are they using an older version?

[@wanroppanthong3874]

Thank you very much. This is a very good idea.

[@teddyfabriciocordovasaenz3018]

Please Sir, teach us to make Quartiles in measures to cotegorized others measures

[@markusleucht6603]

top content as usual, new, fresh and thought through. thanks for doing this.

[@jacveragmail]

I've been trying to find exactly that for years! Thank you soooo much. I'm subscribing from today ! :)

[@HowtoPowerBI]

Thanks for subbing!

[@Removalist666]

You sir are a genius

[@arbazahmad7177]

Another amazing tutorial Thanks for sharing 🎉

[@HowtoPowerBI]

😎👊

[@markmcclure9192]

Bas, could you do a tutorial on using Python in PowerBI? Especially for the Python quick coding of visuals using the Seaborn visuals?

[@mohamedkhafaga6043]

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?

[@MohdArhamIslam]

Can we show the outliers using this technique?

[@asdfxpert]

Amazing, great stuff!

[@glennwright6189]

Another brilliant video, Bas! Unfortunately, the link to download the file doesn't appear to work :(

[@HowtoPowerBI]

oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video kzbin.info/www/bejne/jZDSiGluiZ5rf6c

[@TariqHusam]

you are amazing my bro

[@김차수-k2u]

You are the best!

[@ihueghianful]

This was so fun and enligthing to recreate...Thank you so much.

[@perfectionist6624]

You are the great ❤

[@davidpuddicombe7946]

This is excellent, thank you. Is it possible to flip 90 degrees & make it a horizontal box plot?

[@HowtoPowerBI]

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.

[@LLFY001]

how to make sub calculations?

[@Nalaka-Wanniarachchi]

What a video.legend !!

[@__HumanBeing]

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]

there are already many couple of blogs / vids on this - I dont have so much to add on the topic (for example kzbin.info/www/bejne/r5aXiHyAecuXprs)

[@amanvishnoi9359]

Awesome video. Please share your measure dax.

[@demitredacol]

Excelente! Parabéns!

[@geosmi0]

How do you make the colours different for each box if they are on the same chart?

[@HowtoPowerBI]

with the latest updates in Power BI you can achieve the chart in an easier way kzbin.info/www/bejne/jZDSiGluiZ5rf6c .. then you can just drop a field on legend

[@peterhelms-nielsen8838]

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.

[@JoséSilvaRodriguez-g5w]

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.

[@JoséSilvaRodriguez-g5w]

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.

[@just_pbi]

This is legend @Bas! Can you share a link of your pbix file? I would like to see your measures as well...

[@carlosteixeira604]

How to see the data points ?

[@MaiLe-jc1cn]

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]

You can use the approach in this video 1 Trick for Endless Power BI Charts! kzbin.info/www/bejne/jZDSiGluiZ5rf6c

[@SiamData]

BUT THERS IS NO ERROR BARS IM THE CURRENT BI. HOW CAN WE ACHIEVE THE MAX,MIN RANGE LINE

[@Merrell2780]

Awesome Bas 💪😁

[@arunwats]

How can we add dots for data points like scatter

[@arunwats]

Any help in this please?

[@satellitepop]

Amazing !!!

[@HowtoPowerBI]

😊😎

[@spen2431]

Very clever 😎😎

[@pernillamattsson2227]

how did you make the measures?

[@HowtoPowerBI]

you can download the file from the description then you can see the measures

[@muhammadgad2131]

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

[@Lauren-l3j]

I do not see the error bars option? How can this be fixed?

[@HowtoPowerBI]

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)

[@slickvic06]

Amazinggggg

[@stylianoschiotis5191]

Top!🎉

[@Neg-Power]

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]

i don't think labels can show normal images.. the most you can do is unichar icons

[@Neg-Power]

Thanks but With my case I wanted to show Countries Flag on each data point so I cannot use unichar icons@@HowtoPowerBI

[@nwitachoudhury5361]

no error bar option

[@HowtoPowerBI]

Turn onobject on under preview. Or look in the analytics tab

[@jackbeauregard7041]

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]

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]

@@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]

@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]

@@matthiaseilenbrock Cool, I suppose these are internal matters that you're not allowed to share, right?

[@matthiaseilenbrock]

@@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.

[@sajadahmadi595]

wow 🤩🤩🤩

[@HowtoPowerBI]

😎👊

[@alicedwonderland7733]

How come everyone seems to see the 'Error bar' option but me?

[@alicedwonderland7733]

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]

😁 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]

@@HowtoPowerBI Oh WOW! It is there!!! I'm going back to the non-object interaction WHILE keeping this awesome visual! Bas, amazing as always!!

[@rolenzo]

mitico!

[@HowtoPowerBI]

thanks! 😊

[@JoaoCarlos-qg5cn]

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]

a box plot has nothing to do with correlation... i think you might be mixing some things up here

[@jimip2627]

I have no idea why my power bi is not showing ERROR BARS

[@MsValdesh]

You have a visual names box plots in power bi don't need tu do all this (save time).

[@DataDisciple]

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.

[@napjohn88]

nah was of time

[@naveethsuraj6214]

Bas might not be pregnant but never failed to deliver best Power BI content.

[@HowtoPowerBI]

last time I checked I wasn't pregnant lol :p very confused though .. thx ;)

[@JustRandomExplorer]

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]

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]

@@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)

[@EkaterinaShkabrova]

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?

[@manikyambarao9051]

Hi Bas,Thank you so much for this video.Would it be possible to create drill through to see the details of lower quartile and upper quartile range boxes seperately!?

[@dustyarcher]

Absolute Genius! 💕💕💕it Thank you Bas.

[@SemogOlecram]

By far the best content about Power BI in KZbin. Congratulations, Bas!

[@geineralbertomejiagarzon4034]

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.

[@Bleakmidwinther]

Great tutorial for creating a boxplot! However, when i use the DAX function PERCENTILE.INC(Sales[SaleAmount], 0.25) and PERCENTILE.INC(Sales[SaleAmount], 0.75) and subtract these to find the IQR my IQR bar exceeds the MAX point on several categories. why is that?

[@JennJenn9]

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 🤸🏻‍♂️

[@TheBebwa]

I wonder if it's possible to save time using calculation groups? I find myself creating multiple measures to build different box plots and yet maybe a calculation group would make it easier for me.

[@pabeader1941]

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.

[@luanthanh5976]

Is there a way to show also a dot for each value in the category? Thank you!

[@lucagaidano3779]

The link to the file is not found. You get 404 error

[@jim5400]

Thanks! (again!). Is there anyway of making these plots horizontal please?

[@HowtoPowerBI]

now with the feb 2024 release you can (100% overlap of columns became available).

[@devrupbanerjee3890]

how to integrate the data points in the box plot

[@adolfojsocorro]

Thanks for the video! The download link to the pbix seems broken.

[@HowtoPowerBI]

oops, .. should be there now! ... however the technique is outdated - maybe better to do it like in this video kzbin.info/www/bejne/jZDSiGluiZ5rf6c

[@DanishMehra-hf4ux]

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]

Usually there are points over the max which shows outlier values. Is there a way we can plot those?

[@HowtoPowerBI]

points that are higher than the max? 😅 .. here is an easier way to achieve a boxplot kzbin.info/www/bejne/jZDSiGluiZ5rf6c

[@bbt6630]

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!

[@arunwats]

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!

[@andrewlu8432]

If my dashboard background is dark, how to set tup, the Q1(25%) columns bar how to set transparent?

[@wilconagtzaam587]

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.

[@delidolux]

increadible workshop.... you're my man.👋👋👋

[@brianligat9493]

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.

[@karinsutakova5551]

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?

[@APG67-q8l]

Excelente tutorial. Muchas gracias.

[@hamishmaxa6509]

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.

[@juanignacioXI]

Just Amazing Bas!, thanks for such valuable video.

[@crispybc]

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?

[@beatriceacquah8897]

Could you add data labels to this?

[@HowtoPowerBI]

Yes you could.. with the feb 24 update you could also approach like here 1 Trick for Endless Power BI Charts! kzbin.info/www/bejne/jZDSiGluiZ5rf6c

[@unnikrishnansanthosh]

master BAS, thank you for sharing

[@xyclos]

Great and very useful. Thanks a lot Bass

[@Aquaelus]

*Reinventing out-of-the-box thinking.*

[@piotrkuc8936]

That was so impressive 🎉

[@alicedwonderland7733]

Thank you, Bas! Your work makes mine shine :)

[@HowtoPowerBI]

Happy to hear that thanks for the support