column chart from column values

[Anonymous]

Hi,  I have a table of data, example below.

	Employee 1	Employee 2	Employee 3	Employee 4	Employee 5
Jun-20	100	200	160	200	170
Jul-20	200	180	150	200	80
Aug-20	100	150	150	210	30
Sep-20	70	190	90	240	50
Oct-20	30	45	20	60	40

I have a chart for each employee, that works fine.

I now want to create a chart showing the average for each employee.  

In excel, it would look like this.

[v-diye-msft]

Hi @Anonymous 

What's your expected results?

[amitchandak]

@Anonymous , I think it would be a good idea to unpivot the data

https://radacad.com/pivot-and-unpivot-with-power-bi

Video : https://www.youtube.com/watch?v=2HjkBtxSM0g
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[Anonymous]

This has now messed up my other charts. I rectified this by importing the data again, as a copy.  I was able to make the graph, sort of. but it groups all of the gars in the middle, with large gaps at either end. Also, it doesnt give me the employee names in the x axis.