Forum Discussion
Need help with grouping !!!
Hello all. I am trying to do a "Group By" like I do in Cognos or Excel. I see in Power BI there is an option to create a new "Group" but that is not working the way I need it to. When I look at the ...
Audi_B,
Do you have the GroupName field in your original table? If you have such a field, you can create a Matrix visual following the guide in this article: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual.
However, if you don't have the GroupName field, you can create the field using DAX.
If you can't get expected result in Power BI, please share sample data of your table here as described in this post: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Regards,
Lydia