Swapping X and Y axis in Line chart

[Alex_0201]

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!

[yashwant101]

Hi all,

Did we find any solution/workaround for having the axes swapped on line chart?

Regards,

Yashwant

[ibarrau]

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,

[Alex_0201]

Hi @ibarrau the problem is that the Yaxis (values) is aggregated and therefore the plot is wrong 😕

[ibarrau · Accepted 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,

[Alex_0201]

@ibarrau You might be ritght. I need to test it with a client tomorrow.

[v-xuding-msft]

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