How to list all records in the table, also those "not unique" without aggregation

[karo]

Hi,

Is there a way to see all records in the Table (visual, on canvas), also those "not unique" without aggregation?

Unfortunatelly, "Don't sumarize" is not a solution here.

Example:

In other words, is there a way to see both Anonymous, on 26th of September?

Regards,

Karo

[karo]

Anyone, any ideas? It would be really nice to have an opportunity to show all records in Table Visual on the canvas.

[karo]

Thank you @rsbin for an idea , it can work, but I am more interested in finding a solution where I do not show/add any other column to the view in the table. 

[Anonymous]

Hi @karo ,

Because Power BI is by design, duplicate values are automatically filtered out.

You can post your idea to Ideas . https://ideas.powerbi.com/ideas/

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[rsbin]

@karo ,

There may be more than one solution, but I think the easiest would be to add an Index Column using Power Query.

Then add this Index Column into your table visual.

Trust this solution will work for you.

Regards,