Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group by from a visualization...

Hi, I would like to would like to have a button on my report that it would do a group by for a column in my table visualization control. It should be a toggle action so if I unselect the button the...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!