Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
admin11
Memorable Member
Memorable Member

Why my Closing Date field refuse to display date After today ?

Hi All

I have import the CRM data to PBI , see the image below , 

From below it shown that it have Closing Date from 2024 , 2023 , 2022.

admin11_0-1646051709576.png

From above it prove that i have Closing Date for year = 2022 till 2024.

 

When i create a simple table for Closing Date field , i notice that it only display 2022 Jan and Feb Closing Date. ( When i select Year = 2022 ) 

admin11_1-1646051997235.png

May i know why those date after 28/2/2022 not appear ?

 

Remark :- i have check the filter , i never set filter Closing date < Feb 28 2022 .

 

admin11_2-1646052449180.png

 

Hope some one can advise me where go wrong ?

 

Paul

2 REPLIES 2
amitchandak
Super User
Super User

@admin11 , can you share where you have put filter for 2022

 

If this does not help
Can you share  a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak 

I have send you a private massage , kindly pls reply me.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors