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 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!
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.