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 

 

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Allan,

Thanks this is what I am looking for. I just need to understand how you went to do the group by. It looks as if you selected the visualization and the selections showed the arrows. I am hoping that works when people who view the report not in the Power BI Desktop still can do that. I will give you credit for an answer.