Forum Discussion

Th1sGuy's avatar
Th1sGuy
Frequent Visitor
9 months ago
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...
Need Help
  • parry2k's avatar
    parry2k
    9 months ago

    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 min

     

    For slicer, use value column, and then you can select any value to filter the matrix visual on it.

parry2k's avatar
parry2k
Super User
9 months ago

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 min

 

For slicer, use value column, and then you can select any value to filter the matrix visual on it.