Forum Discussion
Anonymous
6 years agoNot applicable
items with no value still showing up
I am looking at sales data, each line item in data table is a product with a category. When I look at 2020 vs 2019 it still pulls in old categories that have not been sold since 2018 so I have all th...
v-lili6-msft
Community Support
6 years agoHI Anonymous
From the screenshot, it likes you enable show items with no data for categroy field in matrix, could you please share your sample pbix file for us to have a test, there should be something wrong in other.
Regards,
Lin
Anonymous
6 years agoNot applicable
here is a test file
https://www.dropbox.com/s/43azmuya0scr0ld/test%20report.pbix?dl=0