Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jsanjur
New Member

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 employeeTeamRolHTML resultsHTML levelCSS ResultsCSS LevelJS ResultJS Level
Employee ATeam AFront end developer90%495%492%4
Employee BTeam BFront end developer85%490%495%4
Employee CTeam AFront end developer30%250%340%3
Employee DTeam BFront end developer10%120%122%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:

img.PNG

 

 

 

 

 

 

And i will like to get something like this:

editada.jpg

 

 

 

 

 

 

Can you guys help me figure this out, thanks

 

JS

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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/

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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 😊

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.