Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

I have created the unique index as adviced

Item Type Period Site capacity Demand % Index

Item118-OctSite_A5040.000.000.00%1
Item118-OctSite_B1260.00288.0022.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's avatar
    parry2k
    Super User
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous you have drill down to index.