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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Allow Formatting of Dates in X Axis with Continuous Data

Please allow users to specify the date format in which dates should appear on the X axis on visualizations. At present, dates display with times in the X axis if space is available. My data does not have time, and so displays meaningless 12 AM values after the date. I attempted a calculated column using DAX to format date as "m/d" but the visualization continued displaying with meaningless 12 AM values. Changing the model to a non-time format such as text allowed effective sorting, but not treating the data as continuous, which prevents use of trend lines. Please allow users to specify the date format in which dates should appear on the X axis on visualizations.
Status: Needs Votes
Comments
lukas_jasiuken1
New Member
please add this simple fuctionality, its been long submitted.
AHAVERS
New Member
i have a continuous chart that requires that the user only see month/day but not year. very easy to accomplish in excel but impossible in powerbi. please add.
karthik_marupak
New Member
Essential feature for pixel perfect uniform appeal in reports .
eric13
New Member
it should be a basic function and we're waiting it for too long, please add it.
Brannon_Walden
New Member
I've created a date table with a column for month name but as a continuous variable using date as the type. I've formatted the properties to "mmm", but despite this formatting, charts in power bi still display "mmm yyyy" and can't be fixed. Why? The only work around is to create a month number and use that instead. Very disappointing that the formatting works in the table, but not in charts. I would love for our friends in development to help us out with this problem. Thank you.
fozdard
New Member
It's been over two years since this request was submitted. Right now we have to choose between using Categorical and seeing all our dates on the x-axis but trends are disabled, or Continuous with zero control over the date labels on the x-axis but we get trends. Please let us have the best of both worlds?
Tasmin_Langley
New Member
This is really confusing for my report users and has been a problem for a while - please can this be fixed soon!
hhsdform
New Member
Please add this feature! 🙂
Jli3
New Member
It is a very basic function but power doesn't have. It's really very disappointed. Please add it asap!!!!!!!!!!
Brian_Wall
New Member

Running into this with latest install. Would be nice to have this taken care of. Thanks!