Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would appreciate some help with @sorting
I have this table
and i would like to sort the horizontal display of columns by month Jan to December.
The Date Table already contains a numeric column to represent the months (Calendar Month 1-12)
Solved! Go to Solution.
Do it in Data tab
Select Month Name Coulmn then click on the Sort by Column in the upper ribbon Then click on Month No in the dropdown menu
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Do it in Data tab
Select Month Name Coulmn then click on the Sort by Column in the upper ribbon Then click on Month No in the dropdown menu
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
thank you very much @mh2587 i have successfully sorted the table chronologically by month
You can Sort it with month number
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
@mh2587 thank you, how can i see the month number option
my table above has these options, but i am not presented with the month option when tryiing to arrange the month order in the horizontal columns.
The table is currently sorted (alphabetically horizontally) and by Calendar Yeat (vertically)
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |