Table Visual Automatically Adding Multiple Entries

[Anonymous]

Hi,

When using the standard table visual I am experiencing problems with similar data entires automatically adding to each other.

Dataset example

Miles	Start Street	End Street
1	1 town	2 town
5	1 town	2 town

Expected table visual outcome

Miles	Start Street	End Street
1	1 town	2 town
5	1 town	2 town

Actual table visual outcome

Miles	Start Street	End Street
6	1 town	2 town

Anyone know how to stop multiple rows with the same data from automatically adding together when entered into a table visual?

Many thanks,

Elliot  

[amitchandak · Accepted solution]

@Anonymous , Make mile not summarized in a table visual (option on the right click on the field in visual)

Or add index column in power query and use that as not summarized column https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi