How to remove space from bar graph where there is no value

[User0]

HI,
I have a bar chart where I have Year as a dimension. However, for the required measure, there are missing values for a lot of Years and hence it is coming as blank. I want to remove these years from my bar graph. 
please find image for reference .
I just want to keep 2020-2022 .

[sidhiq91 · Accepted solution]

@User0  Try using the Set expression like below: Let me know if this worked.

Sum({<Year={'2020','2021','2022'}>}LineSalesAmount)

[sidhiq91 · Accepted solution]

@User0  or to make it more dynamic, you can use the below expression:

Sum({<Year={">=$(=Max(Year)-2)<=$(=Max(Year))"}>}LineSalesAmount)

[User0]

thank you @sidhiq91 

[User0 · Accepted solution]

I found another solution ,

We can go to chart properties -> Add ons -> uncheck 'include null values'