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.
Thanks in advance!
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.
A workaround would be created a calcuated table to group the data by name and value.
See the example below.
GroupbyName = GROUPBY('Group','Group'[Name],'Group'[Value])
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!!
By my research, it seems that this is by design that won't show the duplicate rows on Power BI.
You could post your idea in Power BI idea froum and add your comments there to improve Power BI and make this feature coming sooner.