HelloI 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.

Anonymous It seems you are using clustered bar chart. Try change the Y axis type from Continuous to Categorical. Paul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Chart not shown every day | Microsoft Fabric Community

3 Replies

Anonymous
Not applicable
6 years ago
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.
amitchandak
Super User
6 years ago
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
Not applicable
6 years ago
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

Forum Discussion

Chart not shown every day