Power BI is merging identical rows. how can I keep them separate?

[KevinSV]

Hello everyone, 

I'm using Power BI and I'm facing an issue where multiple identical rows in my visual table are automatically being merged into a single row.
I would like to keep all the rows exactly as they are, without any merging or aggregation.
In my example, i can add a new column called "LIGNE" which has different data by rows so can separate them but i would like a solution without this column, is that possible ? 
Without "ligne" column : 

With "ligne" column : 

Thanks in advance for your help 🙂 !

[v-saisrao-msft]

Hi @KevinSV,
I wanted to check if you had the opportunity to review the information provided by @lbendlin @johnt75 @kpost . Please feel free to contact us if you have any further questions. If any of the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[kpost · Accepted solution]

Add index column, disable auto-column width, disable 'word wrap' on the column headers, then give the index column zero width so it's not visible to users.

[KevinSV]

Thanks for your reply, i will do it as you explain for this moment 🙂 

[johnt75]

If you want to achieve this in every visual in the report then you could make use of group by columns, https://www.sqlbi.com/articles/understanding-group-by-columns-in-power-bi/ 

If you only want this behaviour in certain visuals, then you could add the ligne column to the visual but set the width to 0, so it doesn't appear to the end user. You may need to turn word wrap off for that to work.

[lbendlin]

Aggregation is one of the fundamental design principles of Power BI. Your approach of adding an index column is the only way to prevent that from happening.