Forum

Data Model pivots -...
 
Notifications
Clear all

[Solved] Data Model pivots - showing blank values

2 Posts
2 Users
0 Reactions
157 Views
(@tallguy2270)
Posts: 1
New Member
Topic starter
 

I have a sheet where I link to cells in a pivot table in a data model for values, but depending on the week there may not be any inquiries to report, so there's nothing to link the sheet to.  I would like the pivot to show each campus and the number of inquiries, or if there are none then show 0's for each. The sheet that is linking to this pivot is pulling inquiry counts for each campus and other information as well as a number of other ones to display all the information in a format the client prefers.  

The pivot would look something like this:

Week filter
Other filters 

Campus  2025 Inqs  2024 Inqs

Campus 1          0                0
Campus 2          0                0
Campus 3          0                0

etc (there are 11 campuses)

Any assistance is appreciated!

 
Posted : 29/03/2025 10:08 am
(@mynda)
Posts: 4760
Member Admin
 

Hi David,

Right-click the Power Pivot PivotTable, choose Options, then on the Display tab, check the box for Show items with no data on rows (or if your data is in columns, check the box for Show Items with no data on columns):

 

Mynda

 
Posted : 29/03/2025 10:46 am
Share: