Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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 , 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/
Thank you. This was very helpful, i was able to do it 😊
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |