Forum Discussion

cst_dev32's avatar
cst_dev32
Frequent Visitor
7 years ago
Solved

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's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity 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_dev32's avatar
      cst_dev32
      Frequent Visitor

      Dear Lin,

       

      Thank you so much for helping me

      :smileyvery-happy: