Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello all,
in my chart, the X-axis acts as the time axis, I would like to format this differently.
I have already searched for entries in the forum, but have not found anything helpful yet.
Currently the chart looks like this:
But I want it to look like this (Screenshot is taken from Tableau):
used data colum looks like this and is classified as data-type "Date":
Thanks in advance!
Hi @Anonymous ,
Go to format pane, change the type of x-axis to "Categorical".
Then change the format of the date column to what you want it to look like.
Best Regards,
Jay
Catagorial is not in the current format.
thank you for your support!
However, by setting type to categorial, a taskbar appears for the X-axis - which is not wanted.
It seems that PowerBi does not allow the formatting of the axes...
@Anonymous , You can create a custom column with sort order column.
But that will not give you continuous axis , as that will be text type column
Month Year = FORMAT([Date],"mm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
135 | |
110 | |
68 | |
55 |