Forum Discussion
Table visual won't show all rows
- Anonymous2 years ago
Hi acorr ,
Thanks for elitesmitpatel and miTutorials reply.
According to your description, you want to display duplicate data in a single form in Power BI table Visualization. Because table visualization displays data on the premise of aggregation, it will make the data more clearly displayed and avoid redundant data hindering reading.
If you want to display duplicate data, you need to have a unique value to rely on, that is, different values to display.
So you can try the following ways:
Sample data
First, you can try to create a random number sequenceTag = RAND()Create a table using INDEX and Tag
Set the table style as NONESet the value and header color as white
Final output
Another way is to add an index column by group in the pwoer query, with the same formatting as the first onelet Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjE1sFSK1UFhGBrAGIYwhhGMYQxjmMAYpjCGGYxhDmNYwBgwk43wmAw0JxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [INDEX = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"INDEX", Int64.Type}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"INDEX"}, {{"Count", each _, type table [INDEX=nullable number]}}), #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Sort",1,1)), #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Sort"}, {"Custom.Sort"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Count"}) in #"Removed Columns"Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi acorr
Here is a quick checklist of steps to follow:
- Verify data load in Power Query and apply changes.
- Check relationships in the model view.
- Review measures and calculated columns.
- Inspect the Filters pane for visual-level filters.
- Ensure correct data types for all columns.
- Check for hidden filters or slicers affecting the data.
- Create a new page and add the table visual to see if the issue persists.