Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
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!
Thanks, that worked!
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |