Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
9 years ago

Table only showing unique values?

Hey Fellow users of Power Bi,

 

As the pictures shown below I have a table with a ton of values, however it only shows the unique values?

Forexample here it only shows 0 once, however I know the values 0 exsists 5 times as shown on picture number 2?

How can this be?

 

General Comment
Need Help
Show and Tell

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    That's just how table visualizations work. If you need all of the instances, then you would need to add something to the table that would essentially make the rows unique.

  • JayHerrera's avatar
    JayHerrera
    Advocate I
    9 years ago

    You can click the dropdown arrow for this field and set to "Don't Summarize", this should display all values instead of "Sum". By default each value you add to a table is set to "Sum". 

    • Shivagange's avatar
      Shivagange
      Frequent Visitor
      8 years ago
      After selecting "Don't summerize" option also it showing unique value.Don't know how data projection is working in power bi.
      • san_jois's avatar
        san_jois
        Resolver I
        8 years ago

        Hi Shivagange,

        Possibly you can try selecting 'Show items with no data' in the dropdown. This may help when the '0' being referred to in a row is not having any other cross references in the base table