Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

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.