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...
  • 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