androidtemplar
8 years agoAdvocate I
Status:
Needs Votes
Show all data in table visualization, do NOT hide duplicates
I see this as a bug, not a feature, when PBI Table visualization sees a row of same values, it assumes them as duplicates and just hides them. If we have a list of employees with 5 John Does, the table visualization shows only one. This is madness. Please fix immediately..at least allow user to toggle "hide duplicates" to OFF. https://community.powerbi.com/t5/Desktop/Duplicate-data-in-Table-visualization-Displaying-as-is-Data/m-p/32353#M11263
6 Comments
- angus1New MemberYes, i agree with this. It's an 'undocumented feature' and not intuitive.
- SThornburgNew MemberI understand that Power BI is an analytical tool for use cases where individual rows are typically aggregated. There are circumstances where I would like to see when there are duplicate rows in a table visual, however. In my particular case, we have a logging table used for drillthrough. The primary page shows a count of entries in the table, and the drillthrough allows users to log at details. There are circumstances where the log data has duplicates, and so the count and the row-level details don't match. I can add an index column, but it's artificially required simply to show the raw data. I would prefer a setting on the table visual to show duplicate rows.
- nbazghalehNew MemberEnd user asking me why they cannot see all 3 records! :) they only can see 1 record!!!! Indexing is not an option for me because table format is determine by government. It is very basic for a table, sometimes we need to pass data to user ! Power BI does not have this basic reporting need! I had same issue previously. I tick show item with no data and it show all. It is not working like that anymore !
- Harold_LiNew MemberThis is a very serious issues I am facing with my application. I'm taking users who are coming from Spotfire, and this is the NUMBER 1 issue they're all struggling with Power BI right now, and the only hack is to implement the idea of an index column.
- Su_GohNew Member
Agreed, most users would regard this as a bug, not a feature. And it really undermines any confidence that end users have in the BI deliverable if countrows says that there are 5 records and the table visualization shows only 1. This is such a rudimentary requirement - why oh why can't we just allow duplicates? Microsoft, if you are still listening in 2023, please finally end this torment.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v8 hours agoCommunity ChampionNew612Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v15 hours agoCommunity ChampionNew17Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019719 hours agoFrequent VisitorNew6Views0likes0Comments