Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |