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 dire...
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
mahoneypat
Microsoft Employee
Microsoft EmployeeYou 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