Show all months in axis for stacked column chart with or without data

[Tcurtis]

How do you show all months if the month has no data? I have tried setting my date to "show items with no data", but that shows all data going back to the beginning of my data set. 

I need a chart to show a 12 month selection using a date slicer and have all months show up even with no data. Is there a selection for this?

I am just putting a stacked column chart on my cava

[Icey]

Hi @Tcurtis ,

It is needed to create another table with all 12 months and then use this month column in your visuals.

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Tcurtis]

I have a date table with all the months in it. I have also tried converting dates to text and using them as the axis and that did not work.

My measure is this:

Lost_Cores = IF(ISBLANK(SUM(tbl_MB51[Quantity])),0,

SUM(tbl_MB51[Quantity]))

But it shows all dates in my dataset and does not filter on my date slicer correctly. All my other measures work with my date slicer.

[Icey]

Hi @Tcurtis ,

Can you create a dummy .pbix file for us to test?

Best regards

Icey

[amitchandak]

@Tcurtis , Try +0 in the measures

or try this approch with +0

https://www.youtube.com/watch?v=duMSovyosXE

[Tcurtis]

This is not related to my issue. 

In access I can force a 0 by using NZ but in Powerbi I cannot force a 0 in a measure it seems and use a date filter on the visual.