Disappearing lines when summarizing columns with null

[kobic]

When you create a table which contains a value number which has null and you add a summary for that columns, the lines with the null disappear thus you don't see all the data. This has to be fixed.

[v-qiuyu-msft · Accepted solution]

Hi @kobic,

You can change the column which are not aggreagted with "Show items with no data" like below:

Reference:
Show Categories With No Data

Best Regards,
Qiuyun Yu