How to expand a table.

[Anonymous]

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!

[Phil_Seamark · Accepted solution]

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

[Anonymous]

Thank you, @Phil_Seamark!