Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |