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

[sherrybay]

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

[Vvelarde]

@sherrybay

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

Select Date

[sherrybay]

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. 

[sherrybay]

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

[kofi123]

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]

@sherrybay

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

[Vvelarde · Accepted solution]

[omikeyz]

Excellent, thank you from Melbourne. 

[NilayEngin]

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. 

[SubhaSakhinala]

Did you get a solution to that?

[MexRedElephant]

Go to:

data view page >

Select the column with a date (click)>

On the top options choose Table tools>

Format> 

Short Date