Simple diagram from excel sheet - should be a no brainer, is it?

[KaiB]

Hi all,

I try to visualize a data source (excel sheet that I can't change) which basically has a formated like this:

Item	Jan	Feb	Mar
a	1	2	3
b	4	3	1
c	5	6	2

And I would like to have a diagram like:

So this is a "standard" user case I would say. And maybe I'm just stupid.

But Power BI somehow puts the Months in the wrong axis, shows the Items on the x-axis, and so on... after hours I ended up asking this here.

All tutorials I have found used tables like this one, where it seems to work out of the box:

Date	Item a
Jan	1
Feb	4
...	...

but I can't change my source.

Can anyone give me a hint / push into the right direction?

Thanks

Kai

[KaiB]

ok. This worked.

Here's a how to: https://www.youtube.com/watch?v=9Xv8COs59tc

In addition I had to add another column based on the "new" month column (Jan ->1, Feb -> 2, ...) so I can sort the month column based on the "month nr" column to make the months show up in the correct oder on the x-axis in the diagram.

In Excel this is a "one click" no-brainer. In PowerBI this is a pain in the a...

Unbelievable

[Greg_Deckler · Accepted solution]

@KaiB I see 2 options. One, in Power Query, unpivot your month columns. Two, you could use DAX Unpivot - Microsoft Power BI Community to create a new table in your model.

[KaiB]

Thanks for your fast answer. I'll give it a go.