I have still not figured this one out. With line chart you can add constant lines but how can you add a constant vertical target line to show the distribution mean in a column chart?
There's an option for an x-axis constant line you could add, which would add a horizontal line for you. Either fixed or as a measure using the (fx) button
How would you go about creating a double bar graph with histogram bins? I've tried simply adding additional bins to the axis and values but that does not seem to display properly
Nice and quick video, as always, thanks! Question though, the bin groups can only be used with a numerical field of a table (or implicit measure), as opposed to a Dax measure. Is my assumption correct?
Hi Nicola, good question. To create custom bins like that you'd need to use a DAX column and specify your own logic in there. There's only a limited amount you can adjust the automatic bins shown in this video
Hi Daniel, so text groups are static. But the bins groups are dynamic in the sense that, if you ask it to make 50 bins. It will adjust the bin size on each refresh to make an even distribution of the 50 bins from the smallest to largest value
Boom! You solved what I thought was going to be a messy problem in under 3 minutes! Thank you for sharing!
DUDE! YOU R AWSOME! loooove your tips and tricks!
It always has been but even more so these days it is all about not wasting time. Thank you for an awesome demo without all the hype and dramatics.
You are a lifesaver brother. Thanks!
Another awesome tip from you guys. Really useful, nice & clean. I do really appreciate it. Thanks a lot!
It was really useful, Thank uuuu😘
Thanks for your explanation, that help me a lot!!!
Love Neha's video, always local and easy to follow!
THANK YOU MATE! YOU ARE GREAT!!
Is it possible to add a vertical Target line in the histogram or is a custom visual required?
I have still not figured this one out. With line chart you can add constant lines but how can you add a constant vertical target line to show the distribution mean in a column chart?
There's an option for an x-axis constant line you could add, which would add a horizontal line for you. Either fixed or as a measure using the (fx) button
@@HavensConsulting yes, but how about a vertical constant line which for example show the mean in a histogram distribution
I never knew about bins. Super useful. Thanks!
Thanks man! great tips! Very helpful!
Thanks for watching 🙂
it is amazing, thank you for your sharing
Thanks for your video. I have a question, is it right to say 'to increase the bin size, you must decrease the bin count'?
What would be the best way to set this up and be able to drillthrough to another page that shows details about the bins/groups?
Amazing trick! Thank you for sharing :)
How would you go about creating a double bar graph with histogram bins? I've tried simply adding additional bins to the axis and values but that does not seem to display properly
Nice and quick video, as always, thanks!
Question though, the bin groups can only be used with a numerical field of a table (or implicit measure), as opposed to a Dax measure. Is my assumption correct?
That’s correct. Bins can only be created off numerical columns. Text columns or measures won’t allow this
Thanks for the tip. Very useful information, since a regular histogram from "Get visual" is very poor and dysfunctional.
Hi man! Great Video! If i desire to create custom bins for example 0-10 11-20 21-30 and 30+? Can I group them in a custom way? Thanx!
Hi Nicola, good question. To create custom bins like that you'd need to use a DAX column and specify your own logic in there. There's only a limited amount you can adjust the automatic bins shown in this video
You can use Power Query to do that - a nested IF statement.
can you make a parameter so that the user can change the size of the bins?
Unfortunately no. They're set during the development process.
The issue is that Groups are static. So data should not change which is most often the case
Hi Daniel, so text groups are static. But the bins groups are dynamic in the sense that, if you ask it to make 50 bins. It will adjust the bin size on each refresh to make an even distribution of the 50 bins from the smallest to largest value
Upload Some videos on DAX Time Intelligence Functions
Noted! Added to my list
I still have no idea what's a "bin".
Lots of good articles on Google if you search for "What is a Bin" :)
My personal favorite www.metabase.com/glossary/bin
Please, you explain too pass and can you start from the beginning
Thanks for the video
Hi Rejoice, if you'd like to slow down the pace you can adjust the video playback speed using the gear icon in the lower right of the video. 🙂