Forum Discussion
How to change table presentation using matrix like one
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
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.
9 Replies
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.
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
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.Hi,
Is the first table of your original post a visual or your raw data?
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.
