Forum Discussion
Grouping Without DAX
hi Anonymous - Couple of watch out while trying to create groups in Power BI
1. You need to create groups for ALL available values in the column (my example Month) you are using to create groups
2. Then you need to add the group and the underlying column into the matrix visual to get the view you are looking for
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
In the URL, please see the scrrenshot above the section entitled "Editing Groups".
https://exceleratorbi.com.au/grouping-in-power-bi-desktop-without-using-dax/
hi John thing is i actually need to see your data to understand your problem. I understand what groups are. Which visual are you using and have you tried to drill down in the visual? How are putting the data you have in the visual. Need more information to understand where there is an issue.
I'm getting a message saying that I do not have permissions to upload screenshots. So, I can't do that.
I'm simply trying to group, just like in Excel and just like in that article says.
I'll figure out drill down on my own.
I just want the group name to shown on one row for each of the records for that group. Easy peesy lemon squeezy.
hi Anonymous - Couple of watch out while trying to create groups in Power BI
1. You need to create groups for ALL available values in the column (my example Month) you are using to create groups
2. Then you need to add the group and the underlying column into the matrix visual to get the view you are looking for
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Thank you, Sumanth_23!!!
This is EXACTLY what I was looking for! And, I just showed our client. He's ecstatic!
You made my weekend!
Thank you, again, Kind Sir!
John
thing is i am not an excel user, so I dont know groupings in excel. However there is more that one way to do things but without some data and only very generalised information its hard to give specific help.