Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors