Unable to create column chart for this specific scenario in Power BI

[Deepak1]

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

[Anonymous]

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

[Deepak1]

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

[jthomson]

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