Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |