How to display full contents of a dynamically created table in a visual

[Jtbonner1986]

Hi Everyone,

I have a dynamically created table in PowerQuery that calculates a 'line of balance' by material, per date. The table plots and calcualtes the this based upon 3 tables within the data model (Material Stock, Material Usage, Material Purchases). Example below;

Line of Balance

Material ID	01/01/2023	01/02/2023	01/03/2023	201/04/2023
123456	5	10	5	0
789	1	10	0	10
54321	0	2	12	5

The columns, apart from [Material ID] are dynamicly created based upon the data that sits within the data model (the date range within Stock, usage, purchases) 

What i need to do is create a visual (Matrix or Table) that can display all this data despite the columns being dynamic and dependant on the date ranges in the supporting tables 

Is this possible?

happy to provide more info or examples if required

Many thanks,

Josh

[Anonymous · Accepted solution]

Hi @Jtbonner1986,

You can do unpivot column on the data fields to convert them to attribute and value.

Then you can use raw table category fields as row ,attribute on the column, value on value to design correspond matrix visualizations.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng