Skip to main content

Power BI

Needs Votes

Allow Formatting of Dates in X Axis with Continuous Data

Vote (183) Share
David Hartung's profile image

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)
David Hartung's profile image Profile Picture

AlexH330 on 06 Jul 2020 00:00:52

RE: Allow Formatting of Dates in X Axis with Continuous Data

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.

David Hartung's profile image Profile Picture

Lukas on 05 Jul 2020 23:55:40

RE: Allow Formatting of Dates in X Axis with Continuous Data

please add this simple fuctionality, its been long submitted.