Table Visualization with grouping

[jcastr02]

I have a table visualization where it has open comments from a survey I'm collecting.  If team members write the same exact commnets, it groups them together vs. seeing the comment repeat numerous times in the visual.  How can we get it to "ungroup"     See excel file below along with visualization (on left).  

[smpa01 · Accepted solution]

@jcastr02  I had this problem few days ago and you are right that for rows with repeated values on the viz window the data is grouped.

Column1

Same value

Same value

Same value

Different value

Different value1

The workaround is to add an index column to the source tabke and bring that index into the viz and have that on Don't Summarize

[amitchandak]

Select the visual. Right-click on the field name in the visualization tab and choose un summarized.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[jcastr02]

@amitchandak Thank you - it looks like I have don't summarize, but still groups repeating items together in the table visual.  the words N/A , pay, the hours, repeat numerous times.  

[PaulDBrown]

@jcastr02 

@smpa01  solution (adding an index column) works like a charm