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 everyone, Is there a way to change the values of an axis dynamically e.g. with a slicer? This would enable a user to easily change the range of an axis, instead of entering new values in the 'Start' or 'End' box. Thanks for your suggestions
Solved! Go to Solution.
Hi @Anonymous ,
Sorry for the delay.
I may misundertood your requirement before.
However, I'm afraid that we cannot achieve your requirement currently in power bi by my tests and research.
You could vote this similar idea which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Cherry
Hi @Anonymous ,
There are several ways for us to achieve that based on slicer.
Please refer to the links below.
https://radacad.com/dynamic-x-axis-on-charts-power-bi
https://www.youtube.com/watch?v=n-OWNaCUU0o
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi Cherry, thanks for your suggestions, however they do not provide a solution for my example.
Basically, I am looking for a way to create slider which controls the value in the End box. For example, the value in the slider is set to 900 and the value 900 is automatically placed in the End box.
Bet regards,
Anton
Hi @Anonymous ,
You can Achieve this using Parameter (What-If-Paramter) where your axis changes as per ranges changes by user in slicer using this parameter.
You can follow the step like below and change as per your needs.
Hi @Tahreem24 ,
Thanks for your suggestion. It is still not clear to me how the value in the parameter will affect the x-axis. What I would like to achieve in the scatter plot below, is to set the x-axis to a lower value than 16 mlns.
Of course I can do that by changing the value in the 'X axis' settings pane from 16 mlns to a lower value. But I am looking for a solution where an less experienced end user can change the value for the x-axis from a slider, and not by going into the X-axis settings pane to change it.
Thank you in advance for your thoughts.
Best wishes,
Anton
Hi @Anonymous ,
Sorry for the delay.
I may misundertood your requirement before.
However, I'm afraid that we cannot achieve your requirement currently in power bi by my tests and research.
You could vote this similar idea which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Cherry
Dear Cherry,
Thanks for your suggestion.
Best regards,
Anton
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |