Just trying to understand this entirely. I think I mostly get it.
Is the measure - Variance EFM % Tracker?
If this is then yes it can’t become an axis on a chart.
This was another post with a similar request to this
The example contain in here is certainly not an efficient way to solve this but an example nonetheless
What I think you really want to be doing here is using supporting (or secondary tables) to group this results.
This is how you can get a physical column that can be used as an axis. It does require create these extra tables but I believe it’s the most efficient way to solve this.
See below for examples on this
https://blog.enterprisedna.co/2018/06/26/secondary-table-logic-inside-of-power-bi-using-dax/
