Is it possible to show table data as-is with no grouping or summarization?

[PaulKraemer]

Hi,

I am new to Power BI.  I find it great for grouping and summarizing data, which is what I will want to do in most cases.  One thing that is unclear to me is whether it is possible to display table data "as is", with no grouping or summarization.  I have created a very simple .pbix file into which I imported a simple table from Excel that just has three rows of two values (Value #1 and Value #2).  I created a Table Visualization linked to this table.  By default (or at least the way that I did it), this visualization just displays a single row with the sum of all Value #1 values and the sum of all Value #2 values.  I am wondering if it is possible to make the Table visualization show the table data "as-is" with no summarization; i.e. with three rows containing three separate values for Value #1 and Value #2.  If I did it correctly, below is a link to my sample .pbix file on my OneDrive....

DisplayTable.pbix

... any advice or guidance will be greatly appreciated.

Thanks in advance,
Paul

[PaulKraemer]

Thank you @Ashish_Mathur and @danextian  - The don't summarize option seems to work great for the simple task I am trying to accomplish today.  I appreciate @danextian's explanation of how this can be a bit more complicated if/when there might be repeating values.  I will keep this in mind for when I run into this.

I appreciate both your help!

Best regards,

Paul

[danextian]

Hi @PaulKraemer 

You can enable don't summarize from the dropdown arrow

However, repeating values will still be grouped there is a another column that differentiates a row from the other. In the image below, Column1 is set to Don't Summarize but since 110 zero has two rows, there are only two rows in the visual instead of 3.

You can add an Index column to differentiate each row

You can can create a calculated column to show a nowidthspace character in the visual instead of the index

[Ashish_Mathur · Accepted solution]

Hi,

Select "Don't summarize"