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.
Hi all,
I have an issue with sorting of months in a cross tab.Need to display the year and month.
But by default it is displaying in alphabelital order. Do we have any work around?
in your modelling tab set the monthname column to sort by column by month number
Proud to be a Super User!
Thank you vanessafvg. I tried it but still it is displaying in alphabetical order.
My requirement is that the month should start with April. So for the financial year it will be 2016-Apr,2016-May and so on
till 2017-Mar.
The Year should be appended along with the month name.i tried sorting on year month number like 2016-04. it does not work even
if i remove the year.
Hi @sudhakar111,
You can try to add a calculate column to convert financial date to numeric, then drag above column to columns field, it may fix the issue.
Numberic Fiscal Date = VALUE(FORMAT([Date],"yyyymm"))
Regards,
Xiaoxin Sheng
Thanks for the response. But i need to display the months as 2016 - Apr,2016 - May and so on and not in numbers.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |