Forum Discussion

MomoJeng's avatar
MomoJeng
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Bar Chart with Dynamic Floating Points Numbers on X-axis

I would like to make a dynamic histogram, where user can filter some floating point data and specify the number of bins in the histogram.   To be specific, I have a table of 10^7 rows in which one ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

At the minimum you need a prepared list of bin ids. These cannot be measures, they have to come from a column.  But it will be possible to filter/restrict how many bins to show.  Realistically anything beyond 10-20 bins won't look good anyway.

 

The problem is that the bin ids cannot be replaced by a different string for display.  So you are stuck with bin 1 to bin 20  on the x axis (for example).

 

It should be possible to create a custom visual for this scenario.

MomoJeng's avatar
MomoJeng
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Yep, if I show the bin idex on the x-axis, then it's definitely possible: that's the custom column chart I created and put a screenshot of in my original question. 🙂

 

It's good to know that I'm stuck with the bin indices on the x-axis, so I will stop looking for a workaround. Thanks!