Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
I want to create a visual like this
Item | 2010 sale | 2011 sale |
clothing | 60 | 75 |
shoes | 150 | 165 |
Thank you in advance!
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |