Group by Month When Headers as Month

[Mcook13]

Hello!

I am very new to Power Bi and could use some guidance.

I imported my Excel tables into Power BI and I need to start building my graphs and models. To start I am building a simple graph for one of my tables so I can get the basics down.

Below is an example of how my table is laid out. The headers are the month (extending to December) with the quantity of that material in that month column.

Material	Average	1-Jan	1-Feb	1-Mar
N567034	501	309	375	200
N528151	77	104	29	80

When creating a bar chart I can't figure out how to sort the data similar to how I have it in my pivot chart below. Any help is appreciated.

 

[sandy666]

I don't know what you want to achieve but maybe

if it's possible post a table with all months

 

[sandy666]

or try this one: pbi.zip