Forum Discussion
Need help with date format
Hi, I used the following measure for month format "Month_Format = FORMAT('Calendar'[Date], "MMM'YY")".
I wanted to show the data of Jan'20 after Feb'19, but I'm not able to do it.
Any help on this would be appreciated!!!!
Hi, Anonymous
Based on your description, I created data to reproduce your scenario.
Table:
Calendar(a calculated table):
Calendar = CALENDARAUTO()There is a many-to-one relationship between two table.
Finally, you may drag 'Year' and 'Month' columns from Calendar table to the visual. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
You need to create sort month column and assign it as sort column
Month_Format_SORT = FORMAT('Calendar'[Date], "YYYYMM")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedinamitchandak Thank you for the prompt response. I'm still seeing the data in the same manner as the snapshot I uploaded.
I hope you sorted your visual by month year. And in visual layer, Click on the column and In column tools check the sort column is correctly set
Hi, Anonymous
Based on your description, I created data to reproduce your scenario.
Table:
Calendar(a calculated table):
Calendar = CALENDARAUTO()There is a many-to-one relationship between two table.
Finally, you may drag 'Year' and 'Month' columns from Calendar table to the visual. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
