How to change table presentation using matrix like one

[Anonymous]

I have one table like the following one

Item  Type	Period	Site	capacity	Demand	%
item1	18-Oct	Site_A	120	10	8.33%
item1	18-Nov	Site_A	120	80	66.67%
item2	18-Oct	Site_A	150	280	186.67%
item2	18-Nov	Site_A	300	450	150.00%

And I want to show the table like this:

Period		18-Oct			18-Nov
Item  Type	Capacity	Demand	%	Capacity	Demand	%
item1	120	10	8.33%	120	80	66.67%
item2	150	280	186.67%	300	450	150.00%

I do not find the way to do it, I thought about using the matrix type vizualization but PowerBI calculate any field (average, count, etc....) instead to report only the values.

Any help is welcome.

LamineM

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Is the first table of your original post a visual or your raw data?

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a matrix as below

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous in matrix it does need aggregation, and you can change the aggregation to max or min , it will meet your needs, only problem you will run into if you have multiple rows for item type and capacity, to overcome this, add a unique index column and put that on the rows, in that case it will never aggregate the values.

[Anonymous]

Thanks Parrry2k for your very prompt answer.

I am trying to understand and set up your solution, will keep you informed.

Best Regards

LamineM

[Anonymous]

I have created the unique index as adviced

Item Type Period Site capacity Demand % Index

Item1	18-Oct	Site_A	5040.00	0.00	0.00%	1
Item1	18-Oct	Site_B	1260.00	288.00	22.86%	406

For each Item Type ( Item1 for example) I have 2 related rows ( for the 2 sites).

When in matrix I change to Min  or Max (capacity and Demand), it display the value ( min or max) not corresponding to the real value of the Site ( Site_A or Site_B)....

I do not understand the "role" of Index...and why PowerBI does not aggregate..

Thanks in advance for any clarification.

BR

[parry2k]

@Anonymous make sure you have added index column on the rows as well.

[Anonymous]

Unfortunately it does work even with "Index Column" in Rows section

[parry2k]

@Anonymous you have drill down to index.