Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Friends,
I have a FYCalendar Table with below columns where FY Starts in JULY:
And a Tickets Table with columns like:
TicketId, CreatedDate, Title, Status, Owner.
I have a Column Chart where X Asix = FiscalYearText and FiscalMonth columns from FYCalendar table and Count of TicketId from Tickets Table. Both the tables are Joined on CreatedDate = Date. I need help on sorting the Columns based on FY and then MonthName. Please suggest how can I get that done.
Thanks,
Prabhat
Solved! Go to Solution.
Hello @prabhatnath ,
click on the month column and then click on the sort column by option and pick the fiscal month num column.
Proud to be a Super User! | |
Hello @prabhatnath ,
click on the month column and then click on the sort column by option and pick the fiscal month num column.
Proud to be a Super User! | |
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |