Forum Discussion

Icon for Advocate II rank

Advocate 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, ...

Icon for Continued Contributor rank

Continued Contributor

10 years ago

AFAIK from MattAllington, to use as axis you have to make calculated column, not measure

chhu
Advocate II
10 years ago
Thanks - I think that is the conclusion I came to. But, is it possible to create a calculated column that does what I want it to - ie calculate a value based on a slicer selection?
- Habib
  Continued Contributor
  10 years ago
  Yes you can but for this you need to use additional table. Please refer to below link. This will give you some idea how to achieve this. This is for excel but you can easily conver this to Power BI :)
  
  http://sqljason.com/2012/11/measure-selection-using-slicers-in.html
  - chhu
    Advocate 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.