Hi everyone. Could someone please explain how to swap X and Y axis in a regular line chart using standard visualization.
Here is how it looks and how it should look like:
Thanks in advance!
Solved! Go to Solution.
Are you sure you want a line chart? line charts aggregate value by category. You need the aggregation for a category like bars. If you want to draw specific y and x axis you might be looking for a scatter chart. You can there specify both axis by details (category).
Consider that the concept of "Values" in any visualization on Power Bi will always aggregate it.
Regards,
Happy to help!
Hi. You can edit the visualization changing your values to y-axis and y-axis to values. That's the only way.
Hope this helps,
Happy to help!
Are you sure you want a line chart? line charts aggregate value by category. You need the aggregation for a category like bars. If you want to draw specific y and x axis you might be looking for a scatter chart. You can there specify both axis by details (category).
Consider that the concept of "Values" in any visualization on Power Bi will always aggregate it.
Regards,
Happy to help!
Hi @Alex_0201 ,
It is not supported for Power BI to swap axises or columns. You could submit the similar ideas:
https://ideas.powerbi.com/ideas/idea/?ideaid=f7c41b5f-9feb-4f71-b487-d61ebc6970fb
https://ideas.powerbi.com/ideas/idea/?ideaid=200a23e9-7d21-4c87-a5ea-940f082ba72e
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
225 | |
54 | |
44 | |
43 | |
43 |
User | Count |
---|---|
274 | |
210 | |
75 | |
71 | |
64 |