Forum Discussion

phenohana123's avatar
phenohana123
New Member
9 years ago

Power Bi Hierarchy Reporting

Dear All,   I would like to know if there is any Power BI Visual Extension so I can work with Hierarchy like   Region - SALES Europe - 1.000.000 - Scandinavia - 500.000 --Finland 200.000 --Sw...
phenohana123's avatar
phenohana123
New Member
9 years ago

Hi Thanks.

I'm not looking for a Graphical,

I'm looking something like a Table.

 

 

 

Cheers!

gooranga1's avatar
gooranga1
Power Participant
9 years ago

can you use the matrix preview visualisaton?

  • phenohana123's avatar
    phenohana123
    New Member
    9 years ago

    https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11g-visual-hierarchies-drilling/

     

    This is the link you sent to me!

     

    But here, you are adding more fields. I just want to have only one hierarchy for Region. Not Region, Country, City in separate. I want to have Region, Country, City in same so I can maintain in one.

     

    This is an example, because I have also Product Hierarchy with 6 level maximum and the last level can be any level!

     

     

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      phenohana123 i dont understand if you combine region, country etc into 1 hiearchy they will work as one?

       

       

       

      • phenohana123's avatar
        phenohana123
        New Member
        9 years ago

        Ok. Let me explain better.

        I only have data from lowest level, in this case countrys, another nodes are whole virtuals.

        for example, I have data from Switzerland and Others not for Central Europe.

        Central Europe is just a "dummy node" where calculate it automatically.

        got it?