Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Swapping X and Y axis in Line chart

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!

Need Help
Tips and Tricks
  • ibarrau's avatar
    ibarrau
    6 years ago

    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,

6 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    6 years ago

    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,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi ibarrau the problem is that the Yaxis (values) is aggregated and therefore the plot is wrong ðŸ˜•

       

       

      • ibarrau's avatar
        ibarrau
        Icon for Super User rankSuper User
        6 years ago

        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,

  • yashwant101's avatar
    yashwant101
    Icon for Helper III rankHelper III
    3 years ago

    Hi all,

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

     

    Regards,

    Yashwant