Skip to main content

Power BI

New

Allow Formatting of Dates in X Axis with Continuous Data

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

f50e1894 006c-4554-900b-da814cbe87c0 on 06 Jul 2020 00:13:32

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

Essential feature for pixel perfect uniform appeal in reports .

David Hartung's profile image Profile Picture

5fe39e96 4540-4a82-931c-52d8bd5de50a 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

cd67bba3 5ab3-42e0-a330-02578f30ee09 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.