Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I'm having immense trouble getting a graph to show the last 6 calendar months in order of the correct month.
Here is what i have on my Calendar table:
[Sort] is a combination of the year and month Jan2022 being 202201, feb 2022 being 202202 etc. I am then sorting it by this value ([sort]) on the table.
Then when I add [sort order] to a graph it has december in the incorrect position on both graphs:
Am I correct to think that if the table is sorted by [sort] the then [sort order] should sort in this order on the graphs?
Can anyone help me please?
additional pic that shows the value in dec2022 is less than Jan2023:
Solved! Go to Solution.
I figured it out in the end.
I needed to select the column I wanted to sort before I click "sort by column". I had just assumed clicing sort by column would do the whole table 🙂
Hello.
In the CALENDAR table you select the MONTH column LETTER
Then, at the top, you choose SORT BY COLUMN and there you choose the column MONTH NRO
And you're done
You tell me xfa
I figured it out in the end.
I needed to select the column I wanted to sort before I click "sort by column". I had just assumed clicing sort by column would do the whole table 🙂
What is the type of the Sort combination column ?
Hi Thanks for your reply and help.
It was set to text but i've just changed it to whole number - but still the same issue on the graphs.
User | Count |
---|---|
112 | |
94 | |
87 | |
75 | |
65 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |