SEE UPDATED VIDEO HERE: [ Ссылка ]
Show Items with no Data in PivotTables is a handy setting that allows you to show items in the PivotTable even if there isn’t any data for them.
Download the Excel file here: [ Ссылка ]
0:18 Example Data
0:39 Regular PivotTable
1:24 Show Items with No Data setting for regular PivotTables
1:52 Power Pivot PivotTables
2:38 Item Dimension Table
2:57 Create Relationship
3:34 Write Measure
4:38 Example 2: dates
View my comprehensive courses: [ Ссылка ]
Connect with me on LinkedIn: [ Ссылка ]
![](https://s2.save4k.ru/pic/mVabPX6quQ0/maxresdefault.jpg)