Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Portal Dashboard - Chart Dates sorted incorrectly

Posted on by 719

Is there a portal site setting to set the format for chart dates? 

I have currently set the site setting DateTime/DateFormat to dd/MM/yyyy however my charts on the dashboard in the portal are sorted by the numerical value of the month. 

For example, this is what my chart looks like in Dynamics 365. The months on the horizontal axis are in the correct order:

Chart_2D00_correct_2D00_sorting.PNG 

This is the same chart in the portal. The months are out of order. Is there any way to fix this?

Chart_2D00_incorrect_2D00_sorting.PNG

  • Zachp Profile Picture
    Zachp 5 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Any update?  Mine is still doing this

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Hi Omer,

    The release date for this bug fix has not been announced.

  • Omer Khan Profile Picture
    Omer Khan 20 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Any update on this bug if it has been fixed? 

  • JohnPhillips Profile Picture
    JohnPhillips on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Microsoft have acknowledged it's a bug and a fix will be rolled out in the next minor update, but couldn't confirm when this would be.

  • RE: Portal Dashboard - Chart Dates sorted incorrectly

    Any news on this?

  • Inksrm Profile Picture
    Inksrm 719 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Thanks Lu Hao. Hopefully they fix it soon!

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Hi Inksrm,

    I tested on my portal and got the same issue.

    I think this is a bug.

    Portal: 1200.4.JPG

    D365: 1200.4.JPG

    I have raised a Microsoft support ticket.

    If I get a solution, I will post it here.

    Hope this helps.

    Best Regards,

    Lu Hao

  • JohnPhillips Profile Picture
    JohnPhillips on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    I know it's no help, but just to let you know that I'm seeing the same issue too and in googling around, I found your thread from just a couple of days ago, so I'm hoping it's a recent bug maybe. It seems to be sorting the dates alphabetically or something like that.

    chart.JPG

  • Inksrm Profile Picture
    Inksrm 719 on at
    RE: Portal Dashboard - Chart Dates sorted incorrectly

    Further to this, I have another chart that is using a view which is sorted by Date (Ascending), and the dates are all out of order. See screenshot below. The dates go from Jan-19, to Dec-18, to Sep-18, to Oct-18...and then the last one is in Jan-19.

    Is this a known issue in portals? Is there a way to fix this?

    Chart_2D00_incorrect_2D00_sorting2.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans