A VISUAL Every Analyst Should Know | HISTOGRAM with Dynamic BINS in Power BI

Подписаться 215 тыс.

Просмотров 45 тыс.

50% 1

UPCOMING POWER BI DESGIN TRAINING! Join me here :)
my.datatraining.io/pages/powe...
In this video I show walk you through how to build a histogram with dynamic bins in Power BI. A visual that can unlock many valuable insights and can be used in almost any Power BI Report. You will see how to create it so that the user can set the bin size - which makes all the difference.
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:19 Why we need bins (buckets)
02:45 Creating a histogram with fixed bin sizes
05:50 Creating dynamic bin sizes - step 1, numeric range parameter
08:36 Creating dynamic bin sizes - step 2, filter on the selected bin size
14:28 Creating dynamic bin sizes - step 3, count within bin measure
18:45 Creating dynamic bin sizes - step 4, bringing it all together
20:47 Creating dynamic bin sizes - step 5, improving the bin labels
24:43 Creating dynamic bin sizes - step 6, integrating the bin size slicer
26: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 RU-vid: 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

Наука

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 67

@HowtoPowerBI 9 месяцев назад

Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation

@ukaszbalcerzak3191 9 месяцев назад

Hi Man, thanks for another great content. Two ideas: 1) in measure Bins Filter , variable _BinsToKeep you could use MOD() = 0 2) in measure Nr of Products within Bin , var _SalesNr - instead of the IF in the iterator maybe you could just leave the boolean expresion (the test) and the SUMX will convert implictly TRUE/FALSE to integers. Or just wrap the logical test in INT() function. I suspect that using IF in the itreator may slow down the measure when there is big number of products. cheers!

@ajinkyatrimukhe 9 месяцев назад

That last part of bins lables was unreal.

@HowtoPowerBI 9 месяцев назад

😁😊 you watched all the way to the end !!? extra thanks to you! 😉

@calinranger1291 9 месяцев назад

Some have already cautioned about this but I thought I'd resatte a potential problem with this visualization. To remove the blank columns in the chart to the right of the maximum value, Bas removed the zero from his if statement which will return blank when False (20:25). But that applies to all columns, not just the ones greater than the maximum value. Therefore bins in the reported range with a frequency of 0 won't be reported. For example, say we have the following frequency count: 0-49: Frequency = 10 50-99: Frequency = 20 100-149: Frequency = 0 150-199: Frequency = 5 200-249: Frequency = 0 250-299: Frequency = 0 .... The graph will only report the follwing bins: 0-49: Frequency = 10 50-99: Frequency = 20 150-200: Frequency = 5 You solved the problem of endless empty columns to the right but created a much more serious problem in the process. Not sure how you'd solve this, probably by calculating the range. Two other considerations while I'm here: 1) You need to know what your possible range will be which isn't always possible; 2) Stragglers/Outliers are going to extend your histogram to the extreme left/right. There's a need for "Bin_Start+" label. Things I think everyone should keep in mind but still by far the best dynamic histogram chart video I've seen! It's crazy that histograms aren't a default visualization from Power BI.

@pk231 9 месяцев назад

You are back with the full flow bro. Kudos for making such extraordinary contents.

@HowtoPowerBI 9 месяцев назад

😊More to come! thanks for watching them

@mazchen 9 месяцев назад

18:31 why do you need the "-1"? Isn't the "

@BobbyRauch 9 месяцев назад

Easily my new favorite Power BI RU-vidr. Like this, any time I'm working on a problem, it seems like Bas comes out with the solution for it with new content. Thank you!

@rigobertogarcia 9 месяцев назад

Excellent video, Bas, as always. This graph is very useful for visualizing statistics of quantitative variables and with all the tips you leave us, it will alleviate the task of constructing and visualizing it properly. Thank you very much, Bas.

@yaynative 7 месяцев назад

I'm gonna have to watch this one 2 or 3 more times.

@worachartchantakraiwat5002 Месяц назад

I followed your video and implemented it for my report to see the distribution of the task completion time for 3 separate workflows using a custom field toggle. The dynamic bin allows users to adjust the bin size with each tick of 5 minutes increment. I don't see how I can turn in the bin label switch but I used the value detail instead and it works great. It's inspiring....Thanks 🙏

@emmafeng55 9 месяцев назад

This is great! Small but very helpful tip for power BI user. Didn’t think of that before. Thanks for sharing ❤

@ilfacone 9 месяцев назад

phenomenal. Im becoming a fanboy of yours Bas. Just great work as always.

@HemanthKumar-lb4xt 8 месяцев назад

Another awesome technique... 🙂Thanks for sharing

@juanignacioXI 7 месяцев назад

Simply outstanding Bas!, thanks a lot

@MrRobvanzutphen1 9 месяцев назад

Awesome as always!!

@Schnappy21 5 месяцев назад

Amazing video dude! Love those little tricks you use in visuals and data labels. I always learn a lot watching.

@jeroenjong9802 9 месяцев назад

Amazing, love your way of presenting, Bas!

@HowtoPowerBI 9 месяцев назад

so nice to hear that 😊 thank you for watching Jeroen!

@detritus666 9 месяцев назад

Super clever solution

@datayoda74 9 месяцев назад

Excellent video

@andrewnewey9354 9 месяцев назад

Your way of sharing is fantastic, and this is another amazing example of that - well done! I wonder if you could assist with the same concept, but I'm interested in seeing price bands over time. Example, if we have (dynamic) bins in increments of 100 and we have selected 3 years of data, I would like to see a column for each year for sales where the price was 0-100, then columns for each year for sales with prices of 100-200 and so on. I would like to be able to drill down from year to quarter to month, but let's just start with the year granularity to keep it simple. Not sure how to do this.

@PeterKontogeorgis 9 месяцев назад

Top bins as usual Bas!! 😂😂😂

@Aquaelus 9 месяцев назад

This is just Amazing. Im hyped already in my next Report to try that out myself. Thank you 🙏

@HowtoPowerBI 9 месяцев назад

Best of luck!

@stephencross4978 9 месяцев назад

Awesome solution and you also helped me with another issue I was having

@HowtoPowerBI 9 месяцев назад

now I'm curious :p what was the other thing .. don't leave me hanging here ;)

@ibrahimalshweair7866 9 месяцев назад

Thanks Baus as always. I would’ve love it more if you had the last bin open ended, like “more than 300” for example.

@HowtoPowerBI 9 месяцев назад

yea that of course works too :)

@krahul456 9 месяцев назад

Wonderful Tutorial !!! Thanks a Lot !!

@HowtoPowerBI 9 месяцев назад

Glad you liked it! thanks!

@rukkyneel2174 7 месяцев назад

No words! Just great, awesome and marvelous. Great intelligence. Thanks brother.

@HowtoPowerBI 7 месяцев назад

👊😎😊

@shahzadkheros 9 месяцев назад

Impressive work

@HowtoPowerBI 9 месяцев назад

💪👀

@dr_zieb 6 месяцев назад

Hi Bas, I'm a huge fan of your tutorials. As a junior Power Bi user I was wondering how you added that sidebar in Power Bi desktop to quickly select the panes for data, visualizations etcetera? I really would like to add that to my Power Bi desktop.

@Daithi354 9 месяцев назад

This worked awesome!!! Just one issue I am having, if I use a slicer to select a product group, any products not part of that group show up as 0 order qty and get dumped into the "0" value on the histogram. I've tried applying a filter to exclude 0 for order qty but it doesn't return the desired result. Is there an easy fix for this that I am missing?

@JoannaHe-zc6jc Месяц назад

Hello Bas, thank you so much for all your videos. Can I ask a question, how to make the histogram to react on other visuals? Such as, if I click on one bar that shows 44 sales orders, can I check which 44 sales orders are?

@mnedix 9 месяцев назад

If only my management wanted this kind of analysis. Kudos for the video, I saved it and I will practice it soon :)

@alexgry4763 9 месяцев назад

Same issue friend! We can create great things, but all they want is a f*cked up E-Mail with some pdf files and an Excel spreadsheets attached...

@HowtoPowerBI 9 месяцев назад

lol let me know if you have been able to convince them :D

@kedarpande 9 месяцев назад

Amazing Video. Lot of leaning

@HowtoPowerBI 9 месяцев назад

thanks for watching! :D

@DJadject 9 месяцев назад

Hi Bas, this video was perfect for my needs. I've been analyzing the time it takes to complete tasks, with the x-axis representing different time units like calendar days, business days, weeks, months, quarters, and years. I believe integrating aspects of your approach will improve the simplicity and output of my application. A change I would make to your approach is not removing all columns with zero values, but rather removing columns greater the maximum number of sales for a product. For instance, if the 25-49 range has zero product counts, but 50-74 has some, it's essential to retain the 25-49 column to avoid the visualisation becoming misleading. A couple of videos that would be really helpful for me: Percentile chart, showing the cumulative percentage of products sold for each bin as a line overlaid on the histogram, with percentages on the y-axis. Using something like the PERCENTILERANK function in Excel (no such function in Power BI). Dynamic y-axis with calendar days, business days, weeks, months, quarters, and years.

@HowtoPowerBI 9 месяцев назад

thanks David 😊 the bins wouldn't disappear, but your approach could also work. I like the cumulative line idea thx! for the dynamic axis check some of the fields parameter videos on the channel :)

@shanmugavelayutham1394 2 месяца назад

Thank you Master ❤

@HowtoPowerBI 2 месяца назад

You are very welcome

@alexgry4763 9 месяцев назад

Adding a BLANK() measure to a visual just to unlock a Grand Total is some next level black magic. Microsoft officials should watch your guides and make these kinds things possible in a normal way. ;) Also, the histogram is great, but I would still go for a calculated column. Enumerating the products in the bin is valuable, but identifying them is even better! Parameter based X-Axis would not provide us a filter context to perform the drill-through unless we cheat and create some additional SUMMARIZE Table of dim Product which would be connected to Bins Filter, having Nr of Products as a value... That would probably work, but it is an overkill IMAO. Could that be done easier?

@mcnater 9 месяцев назад

agree here...good point.

@HowtoPowerBI 9 месяцев назад

if you can have a calculated column that gets the best bin size then I would go for that indeed - not always possible though. The drillthrough you could achieve with a filter measure on the drillthrough destination visuals .. that sounds like a video on its own :p

@nlvq 9 месяцев назад

Great video here lots of tricks in one tutorial -

@HowtoPowerBI 9 месяцев назад

thanks for watching 😊

@maryammoghadam1860 3 месяца назад

Thankssss

@mrutyunjayapradhan3599 9 месяцев назад

Great ❤

@HowtoPowerBI 9 месяцев назад

thank you 😊

@martithon 6 месяцев назад

Would a more efficient way of writing the filter measure be something like: INT(MOD(BinStart, BinSize)=0) ?

@centugurdag7776 8 месяцев назад

now i have seen the smallest attachment icon at the right top corner.thank you

@mazchen 9 месяцев назад

You removed the "right part" of the chart up to 1000 where you didn't have data by removing the "0" in the condition. I guess that would also remove bins in between with no orders. Can you think of a way to keep those gaps?

@centugurdag7776 8 месяцев назад

does it have to be that complicated to download the data set ????, i got membership, but i could not find the data set of this histogram video ?

@Rogustofeles 9 месяцев назад

How to set tabs shortcuts icons on the right side of pbi desktop ( I mean visualisation, data, bookmarks etc. ) ? I use pbi on pro license and I don’t know how to do that.

@RobertoMassucco1978 9 месяцев назад

It's a preview feature that you could enable

@HowtoPowerBI 9 месяцев назад

you need to go to file, options, options and settings, preview features, and check it on there

@Rogustofeles 9 месяцев назад

@@HowtoPowerBI got it! Thanks! I love your videos, helps me soo much in daily work.

@mattjacob7134 4 месяца назад

i have this working on my report for whole numbers but seems to have issues when i tried to used decimals. seems to be any issue somewhere in the Bins Filter measure with the rounding step possibly. anybody try this with decimals and have any luck?

@mihaizamfirescu5357 6 месяцев назад

@ 18:24 I guess you should not deduct 1 from _BinSize_End because in the SUMX filter condition you have ... < _BinSize_End; the change should be OK for