Fixed visual on stacked column chart in month range

[cst_dev32]

Hi,

I want to show data in 1 month range on stacked column chart.

If the data is full for one month, is okey and will showed like this:

but when the data just come up with 1 day in that month, it's just show one bar like this:

i want to show all range of the date in that month just like the first picture, event if the rest of the day of month not exist yet. The data source will generate daily, so the rest of the day will filled up daily too.

How to get this work? please someone help me

thanks

[v-lili6-msft · Accepted solution]

hi, @cst_dev32

     You may try to add a data table then drag field date from date table into Axis and right click to set Show items with no data

Result:

Best Regards,

Lin

[cst_dev32]

Dear Lin,

Thank you so much for helping me