Forum Discussion
Solved
How do I group a matrix by Values?
I have a table similar to the following table built in PBI. There are 4 metrics and they are compared accross 3 dates. however I want to group it like so (which i put together in excel). How d...
If you unpivot the value columns in the query editor, then you can use the resulting attribute column for your column headers.
Getting the formatting how you want it is a separate challenge.
Can you provide a sample dataset? Depending on how your data is pivoted or unpivoted the solution could be rather different.
Here is a mock sample of the data set.
| DC | Location | Capacity % Utilized | Capacity Used (TiB) | Capacity Total (TiB) | Capacity Used (TB) | Capacity Total (TB) | Remaining (TB) | Date |
| HWT | hwtaux000 | 0.65 | 734.00 | 1100.00 | 734.00 | 1100.00 | 366.00 | 10/27/2021 |
| HWT | hwtpri000 | 0.65 | 743.00 | 1100.00 | 743.00 | 1100.00 | 357.00 | 10/27/2021 |
| MRL | mrlaux000 | 0.73 | 1040.00 | 1420.00 | 1040.00 | 1420.00 | 380.00 | 10/27/2021 |
| MRL | mrlpri000 | 0.75 | 925.40 | 1200.00 | 925.40 | 1200.00 | 274.60 | 10/27/2021 |
| VFO | vfaux000 | 0.86 | 883.10 | 1015.00 | 883.10 | 1015.00 | 131.90 | 10/27/2021 |
| VFO | vfpri000 | 0.87 | 985.20 | 1100.00 | 985.20 | 1100.00 | 114.80 | 10/27/2021 |
| HWT | hwtaux000 | 0.65 | 737.80 | 1100.00 | 737.80 | 1100.00 | 362.20 | 11/24/2021 |
| HWT | hwtpri000 | 0.65 | 737.80 | 1100.00 | 737.80 | 1100.00 | 362.20 | 11/24/2021 |
| MRL | mrlaux000 | 0.73 | 1040.00 | 1420.00 | 1040.00 | 1420.00 | 380.00 | 11/24/2021 |
| MRL | mrlpri000 | 0.75 | 924.40 | 1200.00 | 924.40 | 1200.00 | 275.60 | 11/24/2021 |
| VFO | vfaux000 | 0.86 | 883.00 | 1015.00 | 883.00 | 1015.00 | 132.00 | 11/24/2021 |
| VFO | vfpri000 | 0.87 | 985.10 | 1100.00 | 985.10 | 1100.00 | 114.90 | 11/24/2021 |
| HWT | hwtaux000 | 0.65 | 737.00 | 1100.00 | 737.00 | 1100.00 | 363.00 | 12/29/2021 |
| HWT | hwtpri000 | 0.65 | 737.00 | 1100.00 | 737.00 | 1100.00 | 363.00 | 12/29/2021 |
| MRL | mrlaux000 | 0.74 | 1060.00 | 1420.00 | 1060.00 | 1420.00 | 360.00 | 12/29/2021 |
| MRL | mrlpri000 | 0.75 | 935.00 | 1200.00 | 935.00 | 1200.00 | 265.00 | 12/29/2021 |
| VFO | vfaux000 | 0.86 | 879.70 | 1015.00 | 879.70 | 1015.00 | 135.30 | 12/29/2021 |
| VFO | vfpri000 | 0.87 | 981.80 | 1100.00 | 981.80 | 1100.00 | 118.20 | 12/29/2021 |