Forum Discussion

alexkelly101757's avatar
alexkelly101757
Frequent Visitor
7 years ago

creating higher hierarchy from a single table

Hello,   I want to create a hierarchy from a single table.  The table is made up of assets, an asset can be a site, location and sub location, or a asset and the structure is in that order too.  So...
Show and Tell
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi alexkelly101757,

 

One sample for your reference. I create a hierarchy  column by just add the columns to assets one by one.

 

For more details, please check the pbix as attached.

 

Regards,

Frank

 

 

  • alexkelly101757's avatar
    alexkelly101757
    Frequent Visitor
    7 years ago

    Thanks, I've replicated what you've done on my data set with the ID's.  However, my dataset is a bit more complicated than I first explained.  The dataset is tide together by ID numbers, those ID's numbers don't mean anything to the users of the system and are the ones viewing the reports too.  Here's the keys table columns : 

     

    AssettID, SiteID, LocationID, SubLocationID, Description.   

     

    Everyone knows the asset by the description, the ID's are never shown in the software front end and don't mean anything to the people using the software.  However, they are used to link the sites, locations to sub locations and the assets hanging off them.  I need to find a way to display description for each of the Assett, Site, Location, SubLocation.  How can i do this? 

     

    Thanks