David Hartung on 26 Sep 2018 05:53:31
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.
- Comments (22)
RE: Allow Formatting of Dates in X Axis with Continuous Data
Desperately need this resolved, Microsoft. It is impacting one of my reports (with a national audience) and when the report users query, all I can do let them know that it is an existing Microsoft bug.
RE: Allow Formatting of Dates in X Axis with Continuous Data
This is still an issue nearly 6 years later. ridiculous. Please fix Microsoft. Utterly unacceptable and irritating.
RE: Allow Formatting of Dates in X Axis with Continuous Data
This would help me on so many vizualizations
RE: Allow Formatting of Dates in X Axis with Continuous Data
As a user that makes seasonality charts in a commodity market analysis group - this would make our visuals so much better and help us transition out of just Excel
RE: Allow Formatting of Dates in X Axis with Continuous Data
This is definitely a bug Power BI is adding data points that don't exist and assigning data to them randomlyIf the data points that exist are for the 18th Dec 2023 and 19th Dec 2023 dates, the values could be an average for that date, on a continuous x axis of a chart Power BI will assign it to midnight and add additional data points every three hours that do not exist If the data points that exist are for the 18th Dec 2023 00:00:00 and 19th Dec 2023 00:00:00 datetimes the current power BI behaviour is correct for a continuous x axis of a chart. But for a date datatype the current power BI behaviour is wrong as it is creating data that doesn't exist in the source. Reporting software manufacturing data that doesn't exist in the source that its has not been told to create is a bug
RE: Allow Formatting of Dates in X Axis with Continuous Data
Yes this problem confused the users. We really need to have that function
RE: Allow Formatting of Dates in X Axis with Continuous Data
Please do this.
RE: Allow Formatting of Dates in X Axis with Continuous Data
This is most definitely an issue as you cannot add a trend line unless you go to continuous x-axis setting. Please add this to the next update!! All instructions say to switch to categorical x-axis but it looses the trending functionality which is very important for my reporting.Thank you,
RE: Allow Formatting of Dates in X Axis with Continuous Data
Another basic feature missing from this awesome software.
RE: Allow Formatting of Dates in X Axis with Continuous Data
We pay a lot of money for software that cannot show 1 week of output on a graph without separating date data (NOT date/time data) into 12am / 12pm. C'mon guys. This is basic--there is no way date data could be possibly separated into am/pm. I consider this a bug, not a feature. Please fix.