Stacked area showing zeros

Thanks, much appreciated!

Hi. Back to be a pain in the bum again.

I've tried creating my own heirarchies and I've also been able on access your solution on my laptop - but while this approach seems to fix the original problem, it creates others. When I filter down to Month, the months appear to be sorted alphabetically, and also it's not possible to change the access from categorical to continuous, which makes the axis look less pretty, especially on the size of chart I'm looking at (there'll be around 9 of these to a page).

Does anyone else have any other ideas, or do I have to go down the laborious route of updating the end date of the charts every month?

brokencornets look at my blog post on how to correctly sort the months

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/

Looks really useful, I've bookmarked the website for future. However, it doesn't (as far as I can tell) solve the issue of not being about to show the x-axis as continuous, which (given the size of my visualizations) means if I have more than 14 months of data the user will have to scroll left or right to see all the data, which is a bit of a deal-breaker.

brokencornets once you drill down to the date level, you will able to change x-axis type to category and it will work. Let's be very clear here, change the table as a date table wouldn't have an impact on the visualization, you can still achieve the same, it is matter of doing it the right way.