View Full Version : Show variables without data

2016-11-29, 11:59 AM
Dear All, I can't show categories, variables without data in pivot table inserted from data modell. For example I would like to see sales data/every month in a chart, but there is no sales is some of the month.. In "normal" pivot I can choose to see empty cells with no data, but in data model pivots this option is not available. Is there any solution for this? Thank you,

2016-11-29, 07:02 PM
Please don't try to use clour tags on your posts. They don't seem to be working and would be of no benefit.

I suggest that you attach an example workbook