Column chart can't display blank dates

[davidoz]

I'm not sure what changed in PowerBI lately. I used to have no problems doing this and now have had several issues with my dashboards.

I have this column chart which displays in the format I want, but only shows dates where there is a value and excludes the dates where there is no value

my solution was to change the x axis to continuous. Now every date is there, but it displays in this absolutely horrible format

Is there a better solution to this problem?

[v-xinruzhu-msft · Accepted solution]

Hi @davidoz 

You can set the x-axis, then select 'show item with no data'

Then the blank item will display.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[davidoz]

thank you! this worked for me

[Ritaf1983]

Hi @davidoz 
Try to add 0 to your measure:

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly