Forum Discussion
Graph not showing every day
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.
- Anonymous6 years ago
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.
3 Replies
- amitchandak
Super User
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
- AnonymousNot applicable
amitchandak I don't know what you mean. Can you give an example?
- AnonymousNot applicable
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.