cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sherrybay
Regular Visitor

Date splitting automatically into year, quarter, month, and day components

I am a brand new Power BI user. When I move one of my date fields over into a table, it automatically splits into year, month, and day. The users of my report don't need to see the date this way. They just need 5/1/17, for example. And I'm not planning on any calculations. Why is it doing this? I don't want to convert the date to text, because then it won't sort properly. I would be grateful for any help. It's over-complicating things.

 

Thank you!

Sherry

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

7 REPLIES 7
Vvelarde
Community Champion
Community Champion

@sherrybay

 

Hi, Click in the Field and Select Date No Date Hierarchy.

 

Select DateSelect Date




Lima - Peru

Thanks so much for responding so late on a Friday. I see that menu. But it's not letting me uncheck that box. Where exactly do I need to click to get it to activate? Sorry to be so basic. 

I figured it out! Thanks so much for pointing me in the right direction. Muchas gracias! 

I am having similar challenges. In my case, i don't have the fecha option. I need to have the X axis broken into month and year only. Unfortunately, i am unable to do that for the year from 2013 to 2016 which my data covers

Vvelarde
Community Champion
Community Champion

@sherrybay

 

Check the other..In your case the name of your field.

 

 




Lima - Peru
Vvelarde
Community Champion
Community Champion

Do we know how to get rid of the day of the week in this display?

My original data does not have it and I could not find a way to format it. 

I had the same splitting problem and this fix works, but the day names crowd the chart a lot. 

Thanks. 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors