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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
tugar
Employee
Employee

Creating a drill down report in an expand/collapse format.

npr_final.jpg

 

Above, is a report that I want to create using Power BI. The description for this report is as below:

  • It consists of three tables - Table A, Table B and Table C.
  • There is a maximum of three level drill down in this report(the image shows just two levels of drill down, e.g. Total->Baseline Target/Adjustments).
  • On expansion/collapse of any value of Table A(e.g. Total) the next level for all the three tables(i.e. Table A, Table B and Table C) should expand/collapse.

My ask is to achieve the same report using Power BI. How much of this is possible?

 

Thanks!

4 REPLIES 4
tugar
Employee
Employee

Any updates for this report?

 

 

Expand_Collapse.PNG

 

Something similar to the image above will also be helpful.

 

Thanks

Tushar Garg

 

Sean
Community Champion
Community Champion

@tugar Unfortunately we currently don't have Collapse/Expand buttons!

 

Please Vote here if you'd like to see them added to PBI

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

tugar
Employee
Employee

Any updates for this report?

 

Expand_Collapse.PNG

 

Something similar to the image above will also be helpful.

 

Thanks

Tushar Garg

 

Greg_Deckler
Super User
Super User

This looks like a matrix visualization and a couple table visualizations, but it is hard to know if you can achieve the effect you desire without some sample data.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.