Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am unable to change the date format of the x axis. I have read some where that I have to change the type between continuous and categorical, but I don't have that option in the Format section.
I did not see a place to upload the file, but I am happy to share it if you tell me how.
Solved! Go to Solution.
Hi,@LynnZwibak,I am glad to help you. @Ashish_Mathur ,Thank you very much for your help with this question!
I'd like to share my thoughts below.
Here are my test results:
When your X-axis is displayed in full calendar format (with year, month and day)
At this point you don't have this option when choosing Type for the X-axis (choose ‘Continuous’or ‘Categorical’)
solution1:
If you want to display the date column in its original format, you can select the drop-down box for the x-axis in the Filters area and choose to display it as the original column name (just click on the original name of the column), which allows you to select 'Continuous' or ' Categorical'
solution2:
If you only show any of the time columns (in the calendar) in the x-axis, you can show and set the type of the x-axis (choose only one option :Year/Quarter/Month/Day).
Like this:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@LynnZwibak,I am glad to help you. @Ashish_Mathur ,Thank you very much for your help with this question!
I'd like to share my thoughts below.
Here are my test results:
When your X-axis is displayed in full calendar format (with year, month and day)
At this point you don't have this option when choosing Type for the X-axis (choose ‘Continuous’or ‘Categorical’)
solution1:
If you want to display the date column in its original format, you can select the drop-down box for the x-axis in the Filters area and choose to display it as the original column name (just click on the original name of the column), which allows you to select 'Continuous' or ' Categorical'
solution2:
If you only show any of the time columns (in the calendar) in the x-axis, you can show and set the type of the x-axis (choose only one option :Year/Quarter/Month/Day).
Like this:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
What do you mean by "change the date format of the X-axis". Upload the file to a file hosting service such as Google Drive and share the download link. Show the problem very clearly and also the expected result.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |