Forum Discussion

chhu's avatar
chhu
Icon for Advocate II rankAdvocate II
10 years ago

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, ...
chhu's avatar
chhu
Icon for Advocate II rankAdvocate II
10 years ago

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.

 

 

Analyst_PowerBI's avatar
Analyst_PowerBI
Frequent Visitor
8 years ago

Any update?

 

Is it still not possible to use a measure for an axis? Or to filter (e.g. date filter)  a calculated column?