Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

X-Axis Showing time on a date only field

I have a date which from the SQL source was already date data type. Again I changed the data type to date in Power Bi, but for some reason it is still using it on my x-Axis and I can't find a work ar...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    I create a sample and have a test in old version desktop in June and in latest version desktop. I will get the same result like yours. I think you use continuous type in X axis, then too few dates and too large visual size will casue this.

    Here I have two advise.

    1. Use Categorical type in X aixs. 

    2. Keep Continuous type in X aixs. Reduce the size of your visual then your result will show as you want.

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

I create a sample and have a test in old version desktop in June and in latest version desktop. I will get the same result like yours. I think you use continuous type in X axis, then too few dates and too large visual size will casue this.

Here I have two advise.

1. Use Categorical type in X aixs. 

2. Keep Continuous type in X aixs. Reduce the size of your visual then your result will show as you want.

Best Regards,
Rico Zhou

 

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