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.
I'm working with this data from a marketplace. The 3 values that I'm working with are REVENUE , UNITS and VIEWS . Each one of those for each listing and for each day of a whole week .
WHAT I HAVE :
I'm looking forward to get this type of table below. Having in the first row the name of each value ( revenue / units / views ), in the second row the name of the listing and for the next 7 rows the correspondant values for each day of the week .
WHAT I WANT :
I don't care about the order as long as I said before the first row shows the name of each value ( revenue / units / views ), in the second row the name of the listing and for the next 7 rows the correspondant values for each day of the week .
Thanks!!
Solved! Go to Solution.
If you unpivot the three numerical columns on the right, then you can drag and drop the resulting fields into a matrix visual.
If you unpivot the three numerical columns on the right, then you can drag and drop the resulting fields into a matrix visual.
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.