Filtering issue with custom values

[Th1sGuy]

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!

[Praful_Potphode]

Hi @Th1sGuy ,

Please try sample PBIX.

Please give kudos or mark it as solution once confirmed.

Thanks and regards,

Praful

[parry2k · Accepted solution]

@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]

@Th1sGuy is this how your raw data table looks in Power BI?

[Th1sGuy]

[parry2k]

@Th1sGuy how does your data table look like that you used for matrix and slicer?

[Th1sGuy]

Basically this, there are a few more programs at the top being cut off, but this is essentially it: