Forum Discussion

Pasheim's avatar
Pasheim
Frequent Visitor
4 years ago

Switching axes for line chart

Hi,

Quite new to Power BI, but here is my problem:
What I have:
A table in Power BI with disk space data for servers for each separate months

If I choose Clustered columns, I get this (which kind of shows med the development for eachs servers per month)

But when I choose line chart, I get this

What I really want, is something like this

which I get if/when using Excel and switch columns

I have not found any way to do something similar in Power BI Desktop. Have searched this forum as well.
Any ideas, anyone? Am I thinking wrong here?

Best regards

Pål

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Pasheim ,

     

    You may select [VM Name] column and then use "unpivot other columns" to transform the table:

    Then create Line chart:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Pasheim's avatar
      Pasheim
      Frequent Visitor
      4 years ago

      Hi Eyelin,
      Thank you for replying.
      Unfortunatelly your suggestion did not do the trick. I can do the unpovot. but when I try to "Close and Apply" I get duplicate value error