Forum Discussion

gabrielmission7's avatar
gabrielmission7
Frequent Visitor
2 years ago

Line and Clustered Column Chart Conditional Filter on X-axis

Hello! I'm using Line and Clustered Column Chart, and am struggling to display blue bars from Jan to Dec (ie. all bars) but only show red line until April (ie. Jan to Apr) and nothing beyond April. I...
Need Help
sevenhills's avatar
sevenhills
Super User
2 years ago

Without knowing the details of DAX and sample data, data model, it is tough to answer.

 

One best guess is add a new measure to cut off at April or modify the existing measure:

 

Just giving an idea of the measure to filter up to previous month:

 

Calculate (Sum('Table'[Amount]), FILTER('Table',MONTH('Table'[date]) < MONTH(now())))

 

 

If need to hard code, then replace MONTH(now()) as 4.