Show Table in Report, not summarize

[ilcaa72]

I want to show a table in my report and was wondering what is the most efficient way to do this?

can I drag and entire table to the "table visual"?  when i start selecting column within a table vizsualization, it summarizes the values...  i see how i can select each values properties and select "Don't summarize" but it quite annoying to do this to each column..

is there a more efficient way to show a table in report without items being summarized to begin?

[Greg_Deckler]

You could set the default summarization to "Do not summarize" in the Modeling area. 

[ilcaa72]

but that is still on a column by column basis, correct?

i assume everything was summarized because the columns were all numbers.  i assume if i had a string column and selected that first, the rest of the table would come in individual not summarized

[v-piga-msft]

Hi @ilcaa72，

---

@ilcaa72 wrote:

but that is still on a column by column basis, correct?

i assume everything was summarized because the columns were all numbers.  i assume if i had a string column and selected that first, the rest of the table would come in individual not summarized

---

You may need to change default Summaization for each column with number type.

By my test, if you select the column with String type first, the rest column with number type will still be default summarized.

If you have changed the default Summaization of the column with number type to Don't smmarized, it won't be summarized when you drag it to table visualization.

Best Regards，

Cherry