Forum Discussion
Bar chart with lower-level companies
Hi Elijabrnc
Companies use hierarchy structure to manage group of customers and vendor codes where they have more disaggregated branches at the lowest hierarchy level, but can be aggregated into larger (higher hierarchy) group level as they blong to the same group of companies or are branches of a company.
For example, SAP customer master data and vendor master data can maintain hierarchy which allows grouping of data like shown in the below numbering of codes. Once your vendor master data is maintained in that way, Power BI can do its work to visualize that data.
It is better to maintain such master data hierarchy structure in ERP which you are using so that the information is all in one place.
Best regards,
You meen adding an extra Column with the main company name (Comapany X) and then the current Column with Company X North, etc.? And how can i visualis this in an bar chart that it has something like a dropdown function?
- DataNinja777
Super User
Hi Elijabrnc
Companies use hierarchy structure to manage group of customers and vendor codes where they have more disaggregated branches at the lowest hierarchy level, but can be aggregated into larger (higher hierarchy) group level as they blong to the same group of companies or are branches of a company.
For example, SAP customer master data and vendor master data can maintain hierarchy which allows grouping of data like shown in the below numbering of codes. Once your vendor master data is maintained in that way, Power BI can do its work to visualize that data.
It is better to maintain such master data hierarchy structure in ERP which you are using so that the information is all in one place.
Best regards,