Not All Fiscal Year Months do not Appear in Stacked Area Chart

[GJ217]

Hi,

I can't see all my Fiscal Year month's in my Turnover % by Month and Fiscal visual highlighted in yellow.

For some odd reason when I select the Stacked Area Chart visual it excludes Jan, Feb and Mar. Would anyone know why it has done this?

 

[GJ217 · Accepted solution]

Eventually solved this issue and the solution is to ensure that the End Date in the Dates Query  has the end date of the fiscal year which in this case is 31/03/2024 as the calculation required the Headcount figures for the missing months of Jan, Feb and Mar.

= #"Dates Query"(#date(2020, 4, 1), #date(2024, 03, 31), null, null, null)

[amitchandak]

@GJ217 , add +0 your measures

or

try this option

[GJ217]

Hi @amitchandak 

Thanks, all my Turnover % measures already have +0 at the end, tried the "Show items with no data" and nothing  has changed. It's really odd that it does this with the Stacked Area Chart in particular and no other time tracking graph like the Line Chart next to it highlighted in green in my screen shot. 

Any other suggestions are very welcome would really like to solve this one.