Forum Discussion

acorr's avatar
acorr
Frequent Visitor
2 years ago
Solved

Table visual won't show all rows

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?????

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 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 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

     

     

     

     

3 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    2 years ago

    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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 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 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