Creating a graph with double X Axis and original data's date is header

[Yuiitsu]

Dear Experts,

Happy New Year to you all.

I've always been using excel to create a certain graph and now I am tasked to transfer all the presentation slide's graph into powerbi.

One of the graph looks like this:

Here is the base data.

Contract Scope	Apr 22	May 22	Jun 22	Jul 22	Aug 22	Sep 22	Oct 22	Nov 22	Dec 22	Jan 23	Feb 23	Mar 23
Type	Number	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq	svc	Eq
JAC	2	10.2	0.0	5.4	0.0	5.7	0.0	5.6	0.0	5.8	0.0	6.0	0.0	6.2	0.0	5.8	0.0	5.8	0.0	5.8	0.0	5.8	0.0	5.8	0.0
BOE	3	0.8	0.0	0.8	0.0	14.2	0.0	1.1	0.0	0.8	0.0	0.8	0.0	0.8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
BOH	16	6.0	0.0	5.8	0.0	12.1	0.0	3.9	0.0	1.8	0.0	0.4	0.0	3.0	0.0	0.0	0.0	1.7	0.0	0.2	0.0	0.2	0.0	0.2	0.0
Other	15	17.0	0.0	20.4	0.0	21.4	0.0	20.7	0.0	63.8	0.0	10.0	0.0	10.1	0.0	42.8	0.0	9.9	0.0	9.9	0.0	43.0	0.0	9.7	0.0
PPU	4	0.0	11.9	0.0	11.9	0.0	11.9	0.0	11.9	0.0	7.9	0.0	7.9	0.0	14.6	0.0	7.9	0.0	7.9	0.0	7.9	0.0	7.9	0.0	7.9
Total	40	34.0	11.9	32.4	11.9	53.5	11.9	31.4	11.9	72.2	7.9	17.3	7.9	20.1	14.6	48.6	7.9	17.4	7.9	16.0	7.9	49.1	7.9	15.7	7.9

Please help advise me how can i transform this inside power bi? 

Thank you!!

[chrisyan_manalu]

@Yuiitsu 

can you share more your expectation output about your structure data ?

[Yuiitsu]

Hihi!

Expectation will be if possible the same graph as shown

But this was created using excel, kinda easy with my original data:

When I use powerbi it is not possible since the months are the header.

[amitchandak]

@Yuiitsu , For this Month, needs to be in rows.  Unpivot the table if needed (https://radacad.com/pivot-and-unpivot-with-power-bi)

And then have Month and Contract Scope on the axis (Concatenate Label - Off)

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[Yuiitsu]

Thank you for the kind reply.

What about the 2nd row (svc and Eq)?

My table seems to be off but heres a screenshot of how the original table looks like.

Is it possible to create it the same as my excel graph?

[Yuiitsu]

Somehow I managed to did it!

 Thank you!