Forum Discussion
Troubles with my data
Hi All,
I am struggeling to get the data exported from our ERP System in to a visual in PowerBI.
The problem is that with most of the data each collum provides a certain value which you can direct using a different collum. In this case all the usable data, contract hours per team, is allready devided in these collums.
I want to make a visual in which i can put the team numbers on the X-as and use a bar graph to sum up the hours per team.
This is an example of a smal part of the data so you can see what we try to work with.
Example from the data:
| Employee | FTE | Team 1 % | Team 2 % | Team 3 % | Team 4 % |
1 | 1 | 1 | |||
| 2 | 0,8 | 0,7 | 0,3 | ||
| 3 | 1 | ||||
| 4 | 0,9 | 0,6 | 0,4 | ||
| 5 | 1 | 0,8 | 0,2 | ||
| 6 | 1 | 1 |
You should unpivot the data. In the query editor, select the first two columns then right click and choose "Unpivot Other Columns". Rename the Attribute column and use it in your visual to have Team# on your axis/legend. You can Sum the Value column as your values.
Pat
1 Reply
- mahoneypat
Microsoft Employee
You should unpivot the data. In the query editor, select the first two columns then right click and choose "Unpivot Other Columns". Rename the Attribute column and use it in your visual to have Team# on your axis/legend. You can Sum the Value column as your values.
Pat