Desktop visual sorting function & Percentages

[Ryan1802]

Hi i create dashboards for my data on a monthly basis and i need to be able to sort the calendar months in calendar month order. How do i do this?

In addition, i would like to change another chart to show percentage total against month rather than 'grand total' or 'Count' please help

[Tahreem24]

@  For your question 1 sorting order @amitchandak  has answered it so try that out. And regarding your second question please do the following as per screen shot. So that will give you % of total.

[amitchandak]

@ , You need to have sort column

Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])

Mark Month Year sort  as sort column of Month Year