Forum

Notifications
Clear all

Slicer Date Range showing >02-01-2023 (2nd Jan 2023) and Blank for Months where there are Test Entries

2 Posts
2 Users
0 Reactions
135 Views
(@varadphatak)
Posts: 1
New Member
Topic starter
 

Hi Team,

I viewed the Interactive Personal Finance Dashboard for Excel video on YouTube - https://www.youtube.com/watch?v=MRtHNqafufg.

Found it absolutely amazing and for a beginner in Excel, wonderful to have someone explain so well. Now to the error at hand.

I've created the Treemap and while creating its associating Slicers, I get a value of >02-01-2023, which contains all values after that date, even if in the Date Column the date is 11-05-2023 (11th May 2023), and the other Date Slicers do not contain any information.

Attaching the report that I created.

Hoping for someone to help this novice understand and overcome the issue.

 
Posted : 05/01/2023 2:26 am
Riny van Eekelen
(@riny)
Posts: 1201
Member Moderator
 

The report was not attached. Please try again don't forget to press "Start upload" before you submit your reply.

 
Posted : 07/01/2023 2:07 am
Share: