Ok makes sense.
Unfortunately is not possible to make an axis totally dynamic. This is due to the inability to use measures within an axis for a visual.
You can ofcourse create a calculated table that can be determined in size by the measures, BUT this only will update on refresh of your report. So I’m guessing this isn’t exactly what you’re looking for…or it might be?
You could maybe do this is a table only (but couldn’t be turned into a visual) by creating a measure that produced the dynamic X values. There’s obviously downsides to this and I presume this is likely not what you want anyway because the visual is the key with this sort of analysis.
Just also checking if you’ve had a chance to review the below.
Maybe some ideas here that could assist as other have posted about calculating similar things
Sam