Forum Discussion
Need help with table or matrix visual
Hello, I have a table like this Year men clothing women clothing children chothing men shoes women shoes children shoes 2010 10 20 30 40 50 60 2011 15 25 35 45 55 65 ...
In the query editor
- Select your year column, right click and choose unpivot other columns
- Split the Attribute column at the space and name those columns what you want
- Use the column with Clothing, Shoes, etc. in a matrix visual with the Year column on columns and Sum aggregration of the Value column
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeIn the query editor
- Select your year column, right click and choose unpivot other columns
- Split the Attribute column at the space and name those columns what you want
- Use the column with Clothing, Shoes, etc. in a matrix visual with the Year column on columns and Sum aggregration of the Value column
Pat
Thank you very much!