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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
22LACMT
Helper III
Helper III

Dates showing in 2 different ways when using the same field. how do I make them the same.

I used the same ver field to build each visual. One appeared as a breakdown and only will show as the year. the second will only show as the full date (which is the correct way I would like to represent it in all visuals)  

 

1. why is the same field and visual type behaving in two different ways.  how do I get all visuals to show the date as it is represented in the data like example 2?

 

 

1. 

22LACMT_0-1681749162949.png                 22LACMT_2-1681749219809.png

 

2.  

22LACMT_3-1681749290476.png

22LACMT_4-1681749325132.png

 

 

 

          

 

 

 

2 REPLIES 2
22LACMT
Helper III
Helper III

Thank you so much.  I unchecked the auto date in Options.  I then refreshed the data and removed the date from the visual and readded it.  It is still showing as just the year. Did I miss a step? 

Anonymous
Not applicable

Hi @22LACMT ,

 

You are using the date hierarchy created by Auto date/time, it is recommended to turn it off and create a standard calendar table instead.

vcgaomsft_0-1681871951931.png
Auto date/time in Power BI Desktop

You may also consider right-clicking on the ver field to convert from a date hierarchy to the date.

vcgaomsft_2-1681872084178.png

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors