Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 all,
Did we find any solution/workaround for having the axes swapped on line chart?
Regards,
Yashwant
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
94 | |
88 | |
35 | |
35 |
User | Count |
---|---|
154 | |
100 | |
82 | |
63 | |
53 |