Display tabular data as is without aggregation
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.
Has there been a fix to show all records and not automatically remove duplicates?
Steven Hawkins commented
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.
Kulchandra Neupane commented
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.
Stacy Targac commented
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?
Yes, totally agree - I want to show ALL records, even when some are duplicates.
Rodolpho Cunha commented
It's been years since this was discovered... no deal, apparently.
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.
Android templar commented
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. :(
Karen Curtis commented
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.
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)
Agree. Not only that but case sensitivity is quite important. Why would Power Query be sensitive to upper/lower case values while Power BI Desktop is not? It should not assume to aggregate data on column values that are actually different because of case sensitivity
Fred Kaffenberger commented
Tabular data is critical in certain organizations. The ability to see the data as is, without any modifications is important for such things as check registers or purchase orders. Sometimes, there are two items on the same PO, for example, that have the same cost. Currently, the only way to make multiple items with the same values appear is to add a column like a description (not always unique, either) or add an index column in a query, and then put that index into the table, which is meaningless clutter or noise for the report reader.
Team any update on this. Can we now display duplicate rows also in table visualization of power BI?
any update on this? we simply want to display the table data as what is returned on the query.
As per my requirement also i need as it is data.We have option called Keep duplicate but it is not working properly. So i will also recommend to implement feature