Show 0 in my trendline (measure) in month June

[Anonymous]

Hello,

I should see 0 in the month of June, but as you see (blue line) - I do not see anything - the line stops in June...

The measure is here:

Incidents 2022 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year]))

Incidents 2021 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year])-1)

I tried to add+ 0 but it messes up my trendline...

I need to see 0 for the month of June...so far it just looks (blank) - how to replace blank with 0?

Incidents 2022 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year]))+0

[ribisht17]

@Anonymous 

I am not sure why you want to have 0 there.

But if your logic is to show 0 for the present month then it will be simply,

If Month=Current Month then 0 else YOUR Calculation > Incidents 2021 end/This way it will just make 0 for the current month

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users