Any idea how to structure a complex MATRIX with multiple value fields shifting from one to another?

[Anonymous]

Hi,

I have a matrix with around 12 columns * 12 rows where I also want to put 3-4 numeric fields in value (Quantity, Paid Cost, Annual Cost, etc).

Problem is if I put all 3-4 value fields together on table, it will overwhelm audience. Idea is to create a selective bottom/filter to shift from one data field to another. 

Any idea how to structure it?

Thank you!

[Anonymous]

I think the link below may be useful. 

https://community.powerbi.com/t5/Desktop/Adding-Removing-matrix-columns-based-on-Slicer-Filter/td-p/...

If you can post some sample data it would be easier to test. 

[Anonymous]

I intended to achieve this view, without unpivot my targeted data fields since the dataset is super large. Sigh. Probably still have to do it.

[murilopicanco]

Hi
Did you ever find out how to do this? I have the same question.  🙂