Forum Discussion
Matrix using multiple columns w/ same pick list values
Hi all, Been searching for some time and haven't found a good solution to an issue we're having in terms of building out a matrix that takes multiple columns that all have the same pick list valu...
See if this works:
You can get the following by unpivoting and a simple SUM measure
I've attached the PBIX file
Please beware you will need to change the source of the file
Sure. The unpivoting takes place as a step in Power Query, so it will create the unpivoted table automatically once it is set up.
You can share the dummy file using a cloud service or something like wetransfer
that's great to hear. Here's an attempt at sharing the dummy file
See if this works:
You can get the following by unpivoting and a simple SUM measure
I've attached the PBIX file
Please beware you will need to change the source of the file
Thanks again!