Forum Discussion
Solved
Filtering issue with custom values
Hello all, Got another issue I can't quite figure out. I need to be able to filter a matrix with multiple entries using the values of Primary Purpose, Eligible, Co-benefit, and N/A. A piece of th...
Th1sGuy to make it work, you need to unpivot the data;
- transform data
- select question column
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply
To visualize,
- matrix visual:
- add question on rows,
- add attribute on columns
- add value on values section, and use aggregation max or minFor slicer, use value column, and then you can select any value to filter the matrix visual on it.
