Forum Discussion

Adil's avatar
Adil
Frequent Visitor
8 years ago

Matrix empty rows at the aggregate level

Hi Community   I trying to replicate an index scores and ranks in a Matrix table to be able to drill down. the index structure is translated as follows: Level 1: Factrors Level 2: Pillars (each f...
Need Help
Adil's avatar
Adil
Frequent Visitor
8 years ago

Thanks for the reply

is ther a way to make all items in one column (instead of multiple columns while turning off the stepped layout) with their respective scores and ranks?

Also I get the sum of scores and ranks at the higher level instead of their respective values when I drill up. is there a way to fix it?

 

Best regards

Adil

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Adil,

 

I'm not very clear about your requirement.

 

If it is convenient, could you share your desired output, so that we can help further investigate on it?

 

Best Regards,

Cherry

  • Adil's avatar
    Adil
    Frequent Visitor
    8 years ago

    Hi Cherry

     

    Here is the output i want to create:

     

     

    I want to replicate the same on power BI as a matrix with the possibility to drill down and up between the index hierarchy (i.e Factors to pillars to dimensions to drivers and vice versa) while having all items in the same column without empty rows.

     

    Please note the score and the rank at the agregate level isn't necessary a sum of childs.

     

    Thanks

     

    Adil

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      8 years ago

      Hi Adil,

       

      Sorry for the delay!

       

      By my test, I'm afraid that we may not achieve your desired output currently in Power BI.

       

      You could submit your new idea in Power BI idea forum and add your comments there to improve Power BI and make this feature coming sooner.

       

      Best  Regards,

      Cherry