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
RKM
Helper IV
Helper IV

Power BI Matrix - Summary - Detail Table Representation

Dear Experts,

I have one apprantly simple requirement. I historically implemented something like the screenshot below, earlier in a .Net Site.

Now those we are trying to migrate as much possible in Power Bi.

 

So basically an [expandable/collapsable] visual (I guess its Matrix only - in Power BI world), but there is no real calculation here. Just we want to show all employee's by default and if we click to expand - then we want to see his Education history. Is this possible?

RKM_0-1657342718849.png

 

When I tried in Power BI (Several options like, hide [+/ -] or switch off 'Stepped' presenatation etc etc. I could not see how we can break this somewhat like above where it's kind Table within Table.

 

Any help would be greated appreciated. Thanks.

3 REPLIES 3
RKM
Helper IV
Helper IV

Thanks all for your responses. Unfortunately - none fulfilling the requirement here. May be I'll go and add it on 'idea' but not sure how many votes and how many months we'll have to wait in that way..

PaulDBrown
Community Champion
Community Champion

This is the closest I've got...

MTRX.gif

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






v-yanjiang-msft
Community Support
Community Support

Hi @RKM ,

In Power BI matrix, there is expand and collapse only in hierarchy, like below.

vkalyjmsft_0-1657613716288.png

By my test, it's hard to get your desired result now, maybe you can submit an idea in Power BI ideas Forum to improve Power BI.

Best Regards,
Community Support Team _ kalyj

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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