Need some help modelling data to establish parent child relation between columns

[Anonymous]

 Hi all,

I am trying to achieve a solution to establish Parent-child relation between two columns of data. I have provided a sample data sheet with both data level and pictorial representation of my expected result set. I wanted to see if we can write a DAX to dynamically expand the data set showing it's parent-child-child -.... relation . Attaching an excel doc link with detailed explanation and sample mock data set.

Mockup Data

I am open for any suggestion WRT data modelling and visualizations. Thanks in advance.

[Anonymous]

Great, Thanks for the quick turn around. Do you think similar results are achievable with text formatted data? The mockup data i provided is by stripping off the prefixes. Actual data end up looking like "SKC11265" etc., Any workarounds for such data? BTW, with whole numbers this works perfect !!

[Aburar_123]

Hi @Anonymous , you can just change the data type of the columns 'columnA' & 'columnB' into Text in Power BI and check. it is working fine.

[Anonymous]

Thanks, it worked !!

[AlexisOlson]

I think it should still work. If not, you can add index columns in the query editor.

[AlexisOlson · Accepted solution]

Try the Tree custom visual.

Result at default expanded level = 4.

Please see attached.