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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.