Forum Discussion
Creating a Line and Stacked column chart using matrix/pivot data source
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 |
Hi,
Please find attached my solution file.
Hope this helps.
6 Replies
Hi,
Please find attached my solution file.
Hope this helps.
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
Hi,
Please go through the steps in the Query Editor to see the transofrmations carried out.
That worked really well. How can I have Category-1 & Category-2 as stacked values and Category-3 & Category-4 as Lines charts. Thanks!
