Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow Formatting of Dates in X Axis with Continuous Data

Vote (165) 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 (21)
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.