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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mvvessem
Frequent Visitor

Time on the axis of a visual, but field is formatted without time

Hello, 

 

Something strange is going on with my visual. My Date field is also showing a time in the Axis: 

mvvessem_0-1622204944748.png

Only the format in de data table is set to 'Date' only:

mvvessem_1-1622205186995.png

I have used this formula before in other reports without any problem, but now this suddenly occuring.

Does anyone have a solution form this?

Thank you in advance. 

1 ACCEPTED SOLUTION

@mvvessem 

 

Under format options of the Visual change the type of X-Axis from continuous to categorical and see how it looks like

View solution in original post

6 REPLIES 6
mvvessem
Frequent Visitor

Hi @themistoklis,

I have set the date field to this format in the Data View. Only without any effect: 

mvvessem_0-1622207390161.png

The visual stays in the same date/time format. 

@mvvessem 

 

In format options of the Visual change the type of X-Axis from continuous to categorical and see how it looks like

mvvessem
Frequent Visitor

Hi @themistoklis,

Thank you for your reply. The problem is that it is already set to date only: 

mvvessem_0-1622206476469.png

 

@mvvessem 

 

Under format options of the Visual change the type of X-Axis from continuous to categorical and see how it looks like

Thank you @themistoklis ! Good to know. 

 

I did not knew about this option and that this could happen automatically.

themistoklis
Community Champion
Community Champion

@mvvessem 

 

Go to Data View --> Select the date field and check its format.

 

Also make sure you using the correct field in the visual

 

calendar.jpg

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.