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.
Solved! Go to Solution.
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 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
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.
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.