Creating a Line and Stacked column chart using matrix/pivot data source

[RSB]

Hi, I'm pretty new to Power BI. Wondering if somebody can guide me on how to take the below data and create a Line and Stacked column chart . The x-axis should show the Month-Yr and  Y axis should have Categories 1 & 2 stacked. Thanks.

Category	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23
Category-1 (Total)	254	882	925	953	1400	1001
Category-2 (Total)	242	567	790	820	1136	1200
Category-3 (Total)	12	57	71	133	154	139
Category-4 (Total)	27	87	80	80	102	67
Category-5 (Total)	463	667	292	176	89	45

[RSB]

Hi Ashish, Thanks a lot for looking into this. This is how my columns are coming in when I get the data from the excel file into Power BI, not sure how I can link a single date column in Calendar to the multiple date columns. Please advise. Thanks

[Ashish_Mathur]

Hi,

Please go through the steps in the Query Editor to see the transofrmations carried out.

[RSB]

That worked really well. How can I have Category-1 & Category-2 as stacked values and Category-3 & Category-4 as Lines charts. Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my solution file.

Hope this helps.

[RSB]

Thanks, that worked!

[Ashish_Mathur]

Hi,

Please find attached my solution file.

Hope this helps.