Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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 )
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 .
Hope some one can advise me where go wrong ?
Paul
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!