Forum Discussion
Use a measure an an axis (dynamic axis selection)
So, I am trying to create a dynamic column chart, looking at the distribution of employees salary. I would like to be able to give the user the ability to select their own salary intervals (e.g. 2k, ...
Thanks for taking the time to respond - I'm not sure this works though. The essence is that the calculated measure, based on a slicer, can't be used as a axis, or a row/column header in a pivot.
I've pulled together what I've done to show how the data is structured and what works here: http://bit.ly/29a9NSX
Note - ideally I'd like a user to choose any interval, through a text imput box, but I know that's not possible, hence the slicer.
Any update?
Is it still not possible to use a measure for an axis? Or to filter (e.g. date filter) a calculated column?