Showing Zero and blank() on line chart(with timeline) on X-Axis with condition today()

[Anonymous]

Hi,

Having an issue in showing zeros if there is no value until today() and afterwards it should show blank() on the line chart. 

I am counting no. of travels using count function but for last two month there was no travel due to corona situation and hence no data in the database and it shows blank.

I would like to replace blanks() before today() on the timeline

.

Thanks//Jayant

[vanessafvg]

you can use an if( isblank

example

set blank to 0 =
IF (
ISBLANK ( 'CalculatedMeasures'[PreviousYearTotalSales] ),
0,
( 'CalculatedMeasures'[Total Sales] )
)

[Anonymous]

Thanks for the reply.

But as I have shown in attached picture.

Data is available till Mar-2020 and today it is May-2020. so I would like to show from Mar-2020 to May-2020 as zero value rather then blank and after May-2020 it should be blank.

[Anonymous]

Looking for results as shown in picture.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Maybe you could try like this:

No.of Site Travel =
IF (
    MAX ( 'Date'[Date] ) >= TODAY (),
    BLANK (),
    COUNTA ( 'SERT3 Site work'[Site Travel] ) + 0
)

[vanessafvg]

well you can always use your if statement to show blank for values greater than your current date by using blank()