Forum Discussion
Bar Chart with Dynamic Floating Points Numbers on X-axis
Not exactly sure if this will help but please check this article Dynamic Banding or Grouping in Power BI - Using DAX Measures - Choose the Count of Bins - RADACAD
Thanks, Ibendlin! I really appreciate your taking a look and recommending that article.
That article has a fixed list of possible x-values, that they can put in a static table. It's similar to the second "solution" I gave in my original question, where I have a static list of binIndex values (similar to Age in your article). My problem is that I want to show a measure (linearly related to binIndex) on the x-axis. That is, I want the value on the x-axis to be dynamically calculated. At this point I'm guessing that's not possible, but thank you very much for your help!
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.
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!