Graph not showing every day

[Anonymous]

Hi there,

I have dates in my graph as below:

As you can see it always skips one day. How can I fix that? I want to see every date on it. In the graph I use dates from a calandar table which has the data type 'date'. I heard that you should change this to 'Text'. However if I do that it won't work at all. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Do we have values on these "lost date"? Please try "Show items with no data" and see if it helps.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@Anonymous 

You can use date as a date or create text date-sorted on Date of type date column and use that.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak I don't know what you mean. Can you give an example?