Chart not shown every day

[Anonymous]

Hello

I have dates on my chart as below screenshot shown:

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

[V-pazhen-msft · Accepted solution]

@Anonymous 

It seems you are using clustered bar chart. Try change the Y axis type from Continuous to Categorical. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

You need to go to Format- to your axis and change from there the Concatenate labels, Maxium size and Minimum category width. 

Just play little bit there and you will see that all your dates will appear on the axis. 

Give a kudos or select as solution if this helped.

Alin Oprita

[amitchandak]

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