Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Unable to create column chart for this specific scenario in Power BI. Am I missing something?
Below is the sample data that I am having and I want column chart for the same in Power BI. Tried with following data set, but unable to do the same. Please look into this.
Month | Team | Tier | Tickets Solved |
Jan | A | T1 | 15 |
T2 | 12 | ||
B | T1 | 3 | |
T2 | 6 | ||
Feb | A | T1 | 45 |
T2 | 6 | ||
B | T1 | 4 | |
T2 | 8 | ||
Hi Deepak1,
not sure what specific scenario you're referring to, but if you want that data set to work for charting you need to fill in the blanks:
Month | Team | Tier | Tickets Solved |
Jan | A | T1 | 15 |
Jan | A | T2 | 12 |
Jan | B | T1 | 3 |
Jan | B | T2 | 6 |
Feb | A | T1 | 45 |
Feb | A | T2 | 6 |
Feb | B | T1 | 4 |
Feb | B | T2 | 8 |
Had no problem creating charts once it was like this in my PBI desktop.
Thanks,
Thomas
Hi Thomas,
Thanks for your reply. But I want to achieve below behaviour in PowerBI. I tried by filling the blanks as suggested but it did not solve the problem. Via below data set structure, I am able to get column chart in Excel. Tried importing the same data set in Power BI, but failed. Can this be acquired?
Thanks,
Deepak
Fill in the gaps then make a hierarchy between the month and the tier. You may need to play around with sort orders to get things in the exact order you have it, but it works for me
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |