Abhay Kumar on 05 May 2016 03:03:14
Table visualization should have an option to display data as is without aggregation even if there are duplicates. There are scenarios where this is required and it would be great to have this option for users.
- Comments (25)
RE: Display tabular data as is without aggregation
Has there been a fix to show all records and not automatically remove duplicates?
RE: Display tabular data as is without aggregation
We really need this ability in our organization as well. I would have thought that this would have been an easy solution, but this has been happening for years, without solution.
we need this fix in order to visualize our data the way we want to.
RE: Display tabular data as is without aggregation
I want an optrion where user can choose either show duplicate (case sensetive values) or combined. Becuase one option is not best fit for all users. Both option will solver problem for each user.
RE: Display tabular data as is without aggregation
I just want to be able to turn off the auto-remove duplicates when using a table. I think it's a great feature that it removes the dups but sometimes I need it to show the dups. Has anyone heard an update on this?
RE: Display tabular data as is without aggregation
Yes, totally agree - I want to show ALL records, even when some are duplicates.
RE: Display tabular data as is without aggregation
It's been years since this was discovered... no deal, apparently.
RE: Display tabular data as is without aggregation
I also faced the same problem. In the bar graph, it is displayed that there are 11 data. However, since I want to know the details of the data, when I select a table by visualization, only ten data are displayed. Data of the same content was summarized. This result confuses me, so I expect improvement.
RE: Display tabular data as is without aggregation
This is utterly crazy. If we have a list of employees and there are 2 named Sharon Jones, other one of them will be hidden, unless there is a unique-value column (employee_id etc.) in the table visualization.
Power BI should visualize data, not alter it !!!
This is horrible. :(
RE: Display tabular data as is without aggregation
I just ran into the same issue and am really hoping for a solution soon; I have situations where I have to display the duplicate rows and having additional "index" columns for the end users to have to look at is not ideal.
RE: Display tabular data as is without aggregation
A Related request: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33644911-paginated-grid-and-hidden-column
If implementing duplicate row is not possible, then there should be option to add a column and make it hidden (rather than suggested resize option)