Skip to main content
cancel
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

Reply
sabariprabu
Frequent Visitor

Dynamic Text Fields in the Hierarchy Drop Down of Matrix Table

Hi,

 

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

 

Level 1Level 2Level 3Amount
Driver1AluminiumChrome Ore1500
Driver1AluminiumReduce2000
Driver2IronPoet5000
Driver2MetalPottasium4000
Driver3RootMag3000
Driver3OrderRepeat8000
Driver3ExceedOrder22000

 

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.

 

LinkComments
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.   

2 REPLIES 2
v-jayw-msft
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,

Jay

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors