Can X -axis (bins) dynamically vary

[Varshi288]

Hi  

I have a orders data in which there is  a measure MP(TP) where it varries  based on currency selection.Initially I created histogram chart based on the values of the measure.this is hard coded with values  when US currency is selected.Now the requirement is  when any currency selected other than US the x axis should varry accordingly.

I am trying to create bins  on measure MP(TP) but I am not succusfull. 

For ex. if I select the US currency  MP(TP ) values  vary  from 0.1 to  >1.  and if i select INR currency  MP(TP) value vary in between 30 to 45 above. this I need to  show in the  histogram chart.

  IS there any way to change the axis dynamically.

[jamespiggot]

Hi there,

Is there a reason why you don't leave the start and end as auto then it would dynamically scale the axis? If they are blank then the chart will auto-sale the Y axis according to the currency? Apologies if I am missing something obvious!

[Varshi288]

Hi James,

Initially MP(TP) values were calculated  according to  US currency so most of the values are within the range of 0.1 to 1.So Y Axis was hard coded with in these  values. Now MP(TP) values change based on other currecy. Is it possible to  change values on currency selection in a calculated column.