Forum Discussion
Very noob question about how to create a graph
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
Anonymous , 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/
2 Replies
- amitchandak
Super User
Anonymous , 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/