Forum Discussion

danzrust's avatar
danzrust
Helper IV
9 years ago
Solved

Why Is Group By so Difficult in Visualization?

Hi guys, I am wondering and I want to simply understand - why are not values grouped by default in visualization tables?   I have e.g. these values: Keyword Impressions +credit +attorneys 3 +cr...
Show and Tell
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi danzrust,

     

    In Power BI Desktop, you should be able to how Power BI summarizes the data by selecting the Default Summarization icon to change how a field is summarized, including displaying a sum, a count, or an average. Then values will be grouped by default in visualization tables.

     

     

    For more details, you can refer to the following articles. :smileyhappy:

    Customize Visuals with Summarization and Category Options

    Aggregates in Power BI

     

    Regards

danzrust's avatar
danzrust
Helper IV
9 years ago

Okay, I am retarded.

 

For some reason tough, it is greyed out for me. I had to do it via summarizing metrics.

 

Previously, I was just freaking out why a dimension cannot be summed up :)

 

DZ

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi danzrust,

 

Great to hear the problem got resolved! Could you accept helpful replies as solution to close this thread? :smileyhappy:

 

Regards