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
Anonymous
Not applicable

How to expand a table.

Hello,

 

I want to produce the following report:

 

NormalChart

SellerName  ------------ Amount

   +¹Bob                             $10

   +¹Alan                            $50

 

1 -- The "+" is a button, and when I click on it, the ExpandedChart must appears.

 

ExpandedChart

SelleName ------------ Region ------------ Amount

   -²Bob                            North                      $5

                                       South                       $3

                                       East                          $2

  +¹Alan                                                          $50

 

2 -- The "-" is a button and when I click on it the NormalChart must appears.

 

How can I do that? 

 

Thanks!

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Download the new version of Power BI Desktop from here

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/

 

In the options, turn on the Preview New Matrix visual.  This new visual will allow you to add layers for dril down.

 

There is more detail on this here

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#matrix

 

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Phil_Seamark
Employee
Employee

Download the new version of Power BI Desktop from here

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/

 

In the options, turn on the Preview New Matrix visual.  This new visual will allow you to add layers for dril down.

 

There is more detail on this here

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#matrix

 

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous
Not applicable

Thank you, @Phil_Seamark!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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