Forum Discussion

Hoping's avatar
Hoping
Icon for Helper III rankHelper III
3 years ago
Solved

Disable Aggregation on Columns during Personalisation

I have a table visualisation with a number of filters affecting the rows displayed.

 

Even when the row count after filtering is as small as 60 rows, personalising the visual by adding a column and performing an aggregation (SUM or a COUNT) on this coulum results in "Resource Exceeded" error.

 

Is tehre a way to disable aggregation on columns as a quick fix?

 

 

  • Hoping , If it is table visual, you can click on the column in the Visualization pane and use do not summarize

     

    Power Query- Index Column: https://youtu.be/NS4esnCDqVw

     

    If not, then add an index column to table and use that in visual on axis/row/details etc

     

     

2 Replies

  • Hoping , If it is table visual, you can click on the column in the Visualization pane and use do not summarize

     

    Power Query- Index Column: https://youtu.be/NS4esnCDqVw

     

    If not, then add an index column to table and use that in visual on axis/row/details etc

     

     

  • Hi Hoping 
    To switch off the agregations you need choose the option "don't summarize":

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly