Forum Discussion
Group by via table visualization...
- 6 years ago
Hi Anonymous ,
You could reference the blog: Find Out How To Quickly Create Virtual Groups In Power BI to try the feature of Group.
If you need to implement it by calculation, you could take a look at the functions of SUMMARIZE and GROUPBY firstly.
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
GROUPBY – aggregations in data model using DAX (DAX – Power Pivot, Power BI)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Very tough to say exactly without sample data and expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, Matrix visualizations tend to group things nicely. And Table visualizations also do automatic grouping of a sort in terms of aggregations but I am guessing that is not what you are going for.