s F on 11 Aug 2023 16:33:58
Put a dimension into the columns area of a matrix visual like the year:
2018 - 2019 - 2020
Then add two measures, the following happens:
2018 2019 2020
Meas1 Meas2 Meas1 Meas2 Meas1 Meas2
What we want is the ability to change this to the following which is possible in excel with a drag and drop.
Meas1 Meas2
2018 2019 2020 2018 2019 2020