Forum Discussion
Grouping Without DAX
Hi:
The visualization that I have in Power BI Desktop on the left appears just like Excel does - with rows and columns.
And, I just read the article on grouping without DAX in Power BI. I was able to create four groups - one for each sales territory. All well and good.
But, even after adding the group as a column in the visualization on th eleft, I do not see a way to "collapse" the detail based on these groups.
Just like in Excel, I want the detailed rows of data to be summarized by sales territory and give end users the ability to expand and collapse (i.e. drill back). How do I do this?
BTW, somebody wrote an article visually showing how "Rows" can be turned on in the "Visualization" seciton on the right in Pwoer BI. THis selection is not available for me. Strange.
Thanks!
John
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!
8 Replies
- vanessafvg
Community Champion
can you provide some examples of what you looking for its hard to visualise what you are saying. Do you have some screen shots? Creating groups wont necessarily allow you to drill down, you need to create hierarchies for that.
what do you want to do with these rows.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/
- vanessafvg
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.
