1 of 1 people found this helpful
You might try creating your own bins with the below formula, which will allow you to make them continuous, which allows you to set the axis range manually to, for example, show "6" even if it's not in the data.
INT([Value]/[Bin Size])*[Bin Size]-IIF([Value]<0,[Bin Size],0)
See Joe Mako's description here.
Here's another post with a similar question as yours:
In Tableau, I've only created histograms for a handful of measures at a time, where the manual process is fine.
If you have lots of measures that you'd like to histogram, I'm not sure how you can automate this. If it's only for your personal analysis, I'd probably use another tool like R, where this is one or two lines of code. ...
Thanks for your reply. I've resorted to R because this is just too much of a hassle to make it look the way I want in Tableau .
Just another thought, perhaps for future reference, you could reshape the data so that all of the measures are in a single Measure Label column with their values in a second column.
Now you can use Tableau's binning on the second column (or calculate the bins yourself), add the resulting bin field to Columns, Number of Records to Rows and then add the Measure Label to Rows.Now you'll have rows of histograms for each measure.