Table visual won't show all rows

[acorr]

I feel like I am going crazy. Why is PowerBI so needlessly clunky and difficult and unintuitive? Why is the learning curve actually impossible? I waste so much time going around in circles whenever I try to do anything that seems pretty straightforward. There are so few straightforward troubleshooting resources for pretty much anything. I have been through multiple in person trainings. 

Today's problem: I have a single data source and I am trying to use it to create a table or matrix visual. I have created an index column and in PowerQuery it shows every row. I do not have any filters on the visual or page. I have "don't summarize" and "show items with no data" selected for the index field in the visual field settings. Why can I not get all of my rows to show?????

[Anonymous · Accepted solution]

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 sequence 

Tag = RAND()

Create a table using INDEX and Tag 
Set the table style as NONE

Set 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 one

let
    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 He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[elitesmitpatel]

Hi @acorr 

Here is a quick checklist of steps to follow:

1. Verify data load in Power Query and apply changes.
2. Check relationships in the model view.
3. Review measures and calculated columns.
4. Inspect the Filters pane for visual-level filters.
5. Ensure correct data types for all columns.
6. Check for hidden filters or slicers affecting the data.
7. Create a new page and add the table visual to see if the issue persists.

[miTutorials]

Please share sample pbix file to help!