Forum Discussion
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 the dashboard is below for reference.
I am trying to create a filter so that if someone clicks on "Primary Purpose" for example, it only shows which programs are considered a primary purpose for the Questions column. At this point, I doubt a matrix is an appropriate visual for this issue as well.
Any suggestions would be appreciated.
Thank you!
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.
6 Replies
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.
Basically this, there are a few more programs at the top being cut off, but this is essentially it:
Hi Th1sGuy ,
Please try sample PBIX.
Please give kudos or mark it as solution once confirmed.
Thanks and regards,
Praful
