Forum Discussion
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!
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
2 Replies
- Phil_SeamarkMicrosoft 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
- AnonymousNot applicable
Thank you, Phil_Seamark!