Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Dynamic Text Fields in the Hierarchy Drop Down of Matrix Table



I have the below table which has the hierarchy levels and a fact amount field.


Level 1Level 2Level 3Amount
Driver1AluminiumChrome Ore1500


Also I have the below master comments table which has the 1st field mentioning the levels in a concatinated with underscore and also the respective comments for each row.


Driver1_Aluminium_Chrome OreComment 1
Driver1_Aluminium_ReduceComment 2
Driver2_Iron_PoetComment 3
Driver2_Metal_PottasiumComment 4
Driver3_Root_MagComment 5
Driver3_Order_RepeatComment 6
Driver3_Exceed_Order2Comment 7
Driver1_AluminiumComment 8
Driver1_AluminiumComment 9
Driver2_IronComment 10
Driver2_MetalComment 11
Driver3_RootComment 12
Driver3_OrderComment 13
Driver3_ExceedComment 14
Driver1Comment 15
Driver2Comment 16
Driver3Comment 17


Now I need to create a Matrix Table with Level 1, 2, 3 hierarchy and give the respective comment field while performing the expansion and collapse of drill downs (+-) . In general when collapsing the hierarchy the last or min coments appears there by default.


For example :-


The Top level Hierarchy when collapsing should have the comment field as 'Comment 15' as per the master table.

The Next 2nd level hierarchies when expanding should have respecive comments and the same should be followed for Level 3 expansion too.


Please help with the Power BI file too if you can.   

Community Support
Community Support

Hi @sabariprabu ,


I'm not sure if I understood you correcly, but you may consider to split the [link] column to three level columns in Power Query Editor.

It is better share the expected result.


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Frequent Visitor

@amitchandak Any idea on this request ? Can you please help ?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors