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
@ 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.
@ , 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
