Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 around. The wierdest thing is that if I use another date with the same exact settings and data type I can get it to work. Any advice?

 

PBIConfirmedDateOnly.pngPBIDateTime.png

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

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.

1.png

Here I have two advise.

1. Use Categorical type in X aixs. 

1.png

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

2.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

I feel like this should be something that can be controlled but I'm okay with showing the full date instead of Month/day only. Thanks for the help @v-rzhou-msft 

v-rzhou-msft
Community Support
Community Support

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.

1.png

Here I have two advise.

1. Use Categorical type in X aixs. 

1.png

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

2.png

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors