Forum Discussion
Fixed visual on stacked column chart in month range
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
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
2 Replies
- v-lili6-msft
Community Support
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_dev32Frequent Visitor
Dear Lin,
Thank you so much for helping me
:smileyvery-happy: