How can remove future dates with 0 values from the chart?

[jeongkim]

Hi guys,

as the left chart, future periods(from 2023 Apr) are showing while there's no value in query,, so what made such this thing?

[FreemanZ]

hi @jeongkim 

try like:

Measure = 

IF(

    MAX('Date'[Date])<=TODAY(),

    [Accumulative Delivery]

)

[jeongkim]

You mean to make a new measure right? I did so but didn't work,,

[tackytechtom]

Hi @jeongkim ,

How does the measure [sum of delivery] look like? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[jeongkim]

Hi @tackytechtom 

The measure is in the screenshot please see it.