Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What is the best way to sort the fiscal year data by month?
I am using matrix visual. first column is data source and i want to show values for each source in month column. Month should be sorted by fiscal year starting in Nov. 2017-> Oct 2018.
I can have two rows year, month which will sort. But i just want to show the Month names and the they should just be in fiscal year month sequence.
Any feedback on how to accomplish will be very helpful.
thanks
Solved! Go to Solution.
@dhirenp77,
You can create sequence number for your fiscal year month(Nov. 2017-> Oct 2018), the click the YearMonth column, and sort the column by the sequence number column. There is an example for your reference.
Regards,
Lydia
@dhirenp77,
You can create sequence number for your fiscal year month(Nov. 2017-> Oct 2018), the click the YearMonth column, and sort the column by the sequence number column. There is an example for your reference.
Regards,
Lydia
Thanks. That is exactly what i ended up doing.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |