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'm new to Power BI. I want to display a line plot with user selectable X and Y parameters. The display view will be a line plot along with two drop downs XParam and YParam. User can select a parameter from XParam drop down and another parameter from YParam drop down. These parameters will be used as X and Y axes of line plot respectively. How to achieve this in Power BI?
Thank You,
Hi @joshiga ,
You could create two slicers to configure the x and y axis.
Or you could set it from format pane.
Thanks for the reply but this is not what I want to achieve.
Going by your example, I want to have 2 drop downs (instead of the slicers) which will provide options to select column1, column2, column3,..columnN etc. for plotting X-axis and Y-axis. User should be able to plot column3 vs. column5 or, column2 vs column4 by selecting the column names from the 2 drop downs. Any help on this issue is greatly appreciated.
@joshiga , in case you are looking for x-axis as column/text/group by then use
https://www.youtube.com/watch?v=6jeSIRpjv0M
or bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If you want to change measures
Thanks Amit for the quick reply, but I couldn't get how to achieve it through the button, selection pane etc.
Is there any simpler way to achieve this?
I could find how to change X-axis parameter but could not find a solution for selecting parameters for both the axes.
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |