Power bi how to order dates in line and stacked column chart where dates are not unique

Question

 I have a table

Order Date         team  count
1      Jan-20      A     6
2      Feb-20      A     7
3      Feb-20      B     10
4      Mar-20      A     8
:
80     Dec-20      A      12

How do I get orders from Jan-Dec

Answer 1

Use the following measure

Month = LEFT([Date], 3)

which gives a result like this

Month | Sort
Jan   | 1
Feb   | 2
... 

Dec | 12 

Are you willing to learn power bi, Check the Power Bi Developer provided by Intellipaat

Also, watch our YouTube video on Power BI Courses to get yourself started.

For more information on Power BI, check the following Power BI Course!