Very noob question about how to create a graph

[Jsanjur]

Hi all,

So i have a question that i havent been able to figure out for myself so i come to you for help. 

I have a very simple table that im loading to power Bi

Outsource employee	Team	Rol	HTML results	HTML level	CSS Results	CSS Level	JS Result	JS Level
Employee A	Team A	Front end developer	90%	4	95%	4	92%	4
Employee B	Team B	Front end developer	85%	4	90%	4	95%	4
Employee C	Team A	Front end developer	30%	2	50%	3	40%	3
Employee D	Team B	Front end developer	10%	1	20%	1	22%	1

What im trying to do is to have a bar chart that i can filter by Team (A or B) and see a colum of the average of each level (HTML, CSS and JS), but instead if only get a group of the 3 bars together, like this:

And i will like to get something like this:

Can you guys help me figure this out, thanks

JS

[amitchandak · Accepted solution]

@Jsanjur , I think you might have unpivot data for that.

HTML and CSS, should become a row values.

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

I think thrice -https://kohera.be/blog/power-bi/how-to-unpivot-twice/

[Jsanjur]

Thank you.  This was very helpful, i was able to do it 😊