Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
davebates
Regular Visitor

dates on dashboard

help please. I cannot download the desktop version so use the browser version. I am trying to create a dashboad with one of the charts a line chart from an excel spreadsheet of £s over certain periods. In the spreadsheet the periods are month end dates date/month/year eg 31 Jan 2017. When i select the periods for the x axis they appear as month/date/year and the October period appears after the January period. The dates also carry a time format 12.00.00 AM.

 

How do I reformat the dates to be date/moth/year and be recognised as dates.

 

any help would be appreciated

1 ACCEPTED SOLUTION

Hi @davebates,

 

I'm afraid you need the Power BI Desktop. If you want the feature editing in the Service, please create an idea here.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
mehaboob557
Resolver IV
Resolver IV

Hi @davebates,

 

Please follow the below screen shot. You will understand and you can format the date as you have many options,

 

date.png

 

If your issue reolved. Please give a like(kudo) to my answer and accept this anser as Solution accepted

 

Regards,

Mehbub

thanks for the reply. I am not using the Desk top version. Do you know any other way

Hi @davebates,

 

I'm afraid you need the Power BI Desktop. If you want the feature editing in the Service, please create an idea here.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks

Hi @davebates,

 

Could you please mark the proper answer as solution?

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.