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.
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!