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

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.

Reply
livedev
Regular Visitor

How to remove unwant month from Chart?

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.

2022-01-21_16-27-52.jpg

 

6 REPLIES 6
DataVitalizer
Solution Sage
Solution Sage

Hi @livedev 

Do you mean that you want all data except Nov20 and Dec20?

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.

amitchandak
Super User
Super User

@livedev , not clear what do mean by unwanted.

One option I can see is add visual level filter measure value >=1

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

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. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.