Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have created a line chart and my x axis is date field with continues x axis setting everything looks good if I am selecting complete date range.
When I am selecting small date range let say 01/03/2022 to 03/03/2022 my date date period showing the date with time.
My data type for date field is “Date” and format is “dd/MM/yyyy”
Is there any option to remove this time with date.
Complete date range :-
After filter date field :-
I had similar issue with a continuous date field on x-asis. I have solved it by creating copy of my date field and setting up the data type as text. Worked pretty well for me. Give a try.
Regards
Jitendra
Hi @Yagevendra ,
If the type of the X-axis is continuous, it will have time value when the date is too short.
In the visualization format pane, change the type of the X-axis to Catetorical, it works fine.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
thanks for your reply,
Categorical gives the complete date range, in my case I don't want to show complete date range that’s why I selected continues instead of categorical.
Yes, the same thing happing with me when I select 2 or 3 date only it gives the time with date.
Is it bug or need to raise ticket for the same?
Hi @Yagevendra ,
That's how it was designed, there isn't a proper way to format or change the values of the axis whilst in continuous mode. To make Power BI better, you can submit your request at Power BI Ideas and vote it up.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
@Yagevendra -> Did you apply your changes and saved the file?
If not, then try doing that and then pull in the date field into the visual. That's the only way to do it as per my knowledge. Thanks.
@Yagevendra - for removing time with date, go to your transform data, select the date column and make its format as Short date. This will remove the timestamp. Then click on apply changes.
Please hit a thumbs up and mark it as a solution if it works for you. Thank you.
Regards,
TruptiS
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |