Forum Discussion
How to change table presentation using matrix like one
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.
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.
Thanks Parrry2k for your very prompt answer.
I am trying to understand and set up your solution, will keep you informed.
Best Regards
LamineM
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
Anonymous make sure you have added index column on the rows as well.
Unfortunately it does work even with "Index Column" in Rows section