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:             Tha...
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,

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,