Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
79
Views
Topic starter
HI Team,
I have created a dynamic pivot chart and slicers are used. When any tab is selected in a slicer and if the value is 0 for that column, the entire chart is into mess. I have attached the file for your reference. Please try.
Posted : 09/06/2020 2:05 pm
Hi Gunashekar,
Right-click one of the row label fields > Field Settings > Layout & Print tab > check the box 'Show items with no data'.
Note: you'll also need to edit the PivotTable Options > Data tab > in the drop down for 'Retain items deleted from the data source' choose 'None'.
Mynda
Posted : 09/06/2020 7:11 pm
