Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Table chart doesn't show all rows

I have an excel with 16 rows of survey results. In Power Query I added a column that calculates average. 14 rows have a Project ID and 10 rows don't.

When I add a table chart to my report to show all surveys, the table only shows some of the rows, but not all. It averages survey results for all those rows that don't have a project ID number. When I click "don't summarize" it shows only 5 rows with blank Project IDs, not 10. 

How can I show every single row in the table chart regardles if the fields in other columns are the same?

 

Below is example where I selected "count" of average. As you can see it shows 6, and it should show 10.

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    I think that sample source data might make this clear. Posted as text in a table please.
  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi Anonymous 

    If you can show the original data table, it will help us understand your problem better.

    In addition, take a try to create an index column in powerquery and add the index to your table visual.

     

    Best Regards,
    Community Support Team _ Eason