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

Question

Hi,&nbsp;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).&nbsp;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.&nbsp;&nbsp;Any idea how to structure it?&nbsp;Thank you!&nbsp;

anonymous · Answer

I think the link below may be useful.&nbsp;&nbsp;https://community.powerbi.com/t5/Desktop/Adding-Removing-matrix-columns-based-on-Slicer-Filter/td-p/254107&nbsp;If you can post some sample data it would be easier to test.&nbsp;

anonymous · Answer

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.

anonymous · Answer

HiDid you ever find out how to do this? I have the same question.&nbsp; 🙂

Forum Discussion

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

3 Replies

Related content

Table structure

ELT JSON / Semi structured

ELT JSON Semi Structured Loop

Importing multiple sheets with same structure

Spark Structured Streaming Continuous mode