Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |