Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I create DAX for the last N month from a select year, my data result correct is correct but there is unwant data as well. How to remove it?
From this picture, I need only a red box.
No, I need Jan 2020 - Oct 2020 only.
Hi @livedev
Correct me if I am wrong, when selecting the year 2020 you want only months from Jan 2020 to Oct2020 to appear? Or you want your visual to be shwing only that range of date?
SelectN => How many month need to show in graph?
Month => Start from month
Year => What year need to show?
Example: if I SelectN = 12 and Month OCT and Year 2020,
Normally, data must be displayed from OCT 2019 - OCT 2020. I added a condition that it will only display start from Jan even though I choose to show the past 12 months.
Currently, I do the same you suggest, but I need to finish my result on DAX don't need to apply it in the visual filter.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.