Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Resolver I
Resolver I

Can X -axis (bins) dynamically vary


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.range3.PNGrange2.PNGrange1.PNG

  IS there any way to change the axis dynamically.


Frequent Visitor

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!








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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors