column chart from column values

Question

Hi,&nbsp; I have a table of data, example below.&nbsp;Employee 1Employee 2Employee 3Employee 4Employee 5Jun-20100200160200170Jul-2020018015020080Aug-2010015015021030Sep-20701909024050Oct-203045206040&nbsp;I have a chart for each employee, that works fine.&nbsp;I now want to create a chart showing the average for each employee.&nbsp;&nbsp;&nbsp;In excel, it would look like this.&nbsp;&nbsp;&nbsp;

amitchandak · Answer

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=2HjkBtxSM0gTranspose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

This has now messed up my other charts. I rectified this by importing the data again, as a copy.&nbsp; 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.

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
What's your expected results?
&nbsp;
&nbsp;

Forum Discussion

column chart from column values

3 Replies

Related content

Splitting Column values

Matching Column Values

Check column for similar values

New Column

Grouping rows by Column and then updating Column

	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