Forum Discussion
Grouping Columns in Visualisation
How in power bi we can group columns in table visualisation. I need to give this similar functionallity in Power BI. I am aware of row level grouping but at the column level can any share his thoughts or way around in which we can just click and group / ungroup columns. Columns to hide can be 10 also in numbers.
3 Replies
You can put multiple dimensions in the columns, but if you're looking to group dates, that should already be a feature that you can use through enabling date heirarchy.
Hi
Thanks for replying!
I need to group columns which are measures not dates and i need to show a sum of them in each column. When a click on group selected columns should hide under them like we do in an excel.
I am using a Table chart for my visualisation. Please do let me know what is the best approach and what chart type i should use.
Hi Iamsumitsandhu ,
Unfortunately, at this time, tables and matrix do not have the ability to group columns. Therefore, we encourage you to show your support for this idea by voting.
Please add feature to group columns in matixBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
