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 ...
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.
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
