Forum Discussion
Power BI Table Visual not showing double rows
Hi all
I've been searchig for a while now, and I think I'm missing a simple property but I can't figure out where to find it...
I'm searching for the ability to show all records (not only the distinct records) in my Table visual.
My datasource is an excel file with these values
Name | Value | Id
A | 1 | 1
B | 2 | 2
C | 3 | 3
A | 1 | 4
In my table I only want to display columns Name and Value.
When I do so, my last record with Id 4 isn't visible.
The result is:
Name | Value
A | 1
B | 2
C | 3
If I add the Id column to the Values of my table, all records are visible.
I've already set the 'Don't summarize' setting fo the Name and Value column.
Any ideas?
Thanks in advance!
12 Replies
Hi jeroenc,
I could reproduce your scenario, but I think that's by design.
Normaly, if you don't drag ID to visual, Name A only match Value 1 so it only show one distict row.
If you show count of Value, you will see 2 like below.
Best Regards,
Cherry
Hi v-piga-msft, Anonymous
Both thanks for the reply, but we are searching for a way to display all rows without grouping and without adding the unique Id column.
Any other solutions?
Thanks!
Really nice execerise , i tried 1-2 hours, change data types, change filters and... but did not get.
Curious to know the solution.
Hi All
Is there any movement on this topic?
I also want to display all rows in a table but without the ID as this takes up valuable space in the model!!
Thanks
Mattie
Hi All,
I have same issue and I find it really frustrating that it has not been fixed since 2.5 years.
I don't think it is by design, as it simply behaves as if the summarization option was set to first.
I raised an idea to fix that in a link below:
Microsoft Idea · Change behavior of table when showing duplicate rows (powerbi.com)
Please vote on it to get attention from developers and hopefully it will be fixed.
Thank you in advance.
