Forum Discussion
Group by via table visualization...
Hi All,
I understand you can write the group by in SQL when you get data or a group by applied vi group by via Power Query. Can we do a group by on a table visualization? The data for that visualization comes from multiple tables so I feel it is better to do the group by at that level.
Thanks.
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.
3 Replies
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.
I believe you are right! I did run into an issue where I get errors for a balance where I am thinking I need to look at summarize.
Also with the other suggestions about Group By and we also have slicers that the combination of the two is not possible. It seems like it might be since the slicer is modifing the where clause I think,
Anyway thanks everyone for the help!
-Tony
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.
