How to show all values if values is duplicate

[komkit]

 

There are 3 data in the table.  but in matrix  visual There is 1 data. how to show all data

[amitchandak · Accepted solution]

@komkit , for that you have to index the column and bring it visual as not summarized

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

[Ritaf1983 · Accepted solution]

Hi @komkit .

Unfortunately, there is no way to display duplicates line by line.
Additionally, by adding an index column, the number of rows can be opened based on their repetitions.
Please see the attached link.
https://stackoverflow.com/questions/69539709/keep-duplicate-data-in-matrix-visual-power-bi 
If you still need to see every repetition visualy, you could use the connection between the category and its index and display either as an additional hierarchy or on its own.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos 🙂

[amitchandak · Accepted solution]

@komkit , for that you have to index the column and bring it visual as not summarized

Power Query- Index Column: https://youtu.be/NS4esnCDqVw