Forum Discussion
Group by from a visualization...
Hi, Anonymous
Based on your description, you may try using drill up/down. Here is my sample data.
Result:
However, when exporting to a Excel file, you will get all data in the original table.
For further information, you may refer to the following link.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks but when I select the Table visualization that I have populated with data the drilldowns symbols do not show up. I noticed you used the Matrix one and when I added it to the canvas it did not show up the drill down symbols. That leads me to believe there is more to this. I will not give up on this appraoch since it has merit. The link you provided uses a different visualization but did mention the data has to be hierarchtical. I am wondering if that is a hint about how to get what you mentioned to work.
Best Regards,
-Tony
Hi, Anonymous
You need to select the drill down icon to turn it on when there is a next hierarchy to drill down . If not, selecting a visual element won't drill down. Instead, it will cross-filter the other charts on the report page by default. Please pay more attention to the article . It may help.
Best Regards
Allan
Sorry but none of those icons show up in the table visualization. That is why I suspected there is more to this than just that. I believe the data has to be setup in a heiarchtical manner to begin with.
Again Thanks!