Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings,
I'm doing a Sales Report and I'm unable to get my bar chart to sort the Months in order. My Slicer is a list of "Sites" and when I select a site I want to see the values for each month over the course of the past 3 years.
In my data I've got a column for:
1. Year
2. Month (Text: January, February, March, etc)
3. Month Number (January is 1, February is 2, etc)
Everything looks exactly how I want it to with the exception of these months not showing up in chronologic order. How can I solve this? Do I need to make a new measure?
Solved! Go to Solution.
sounds like you just need to edit the month column and set the sort by column property to Month Number
then on the graph, select the ellipsis in the top right and set it to sort by Month. you may need to select this twice as I think the first time it sets it to descending order.
sounds like you just need to edit the month column and set the sort by column property to Month Number
then on the graph, select the ellipsis in the top right and set it to sort by Month. you may need to select this twice as I think the first time it sets it to descending order.
Worked Perfectly!!
Thanks!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |