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.
Hello All,
I have an Excel table with a date column and the next column contains this formula
=TEXT(B222,"MMMM")
which as you know extracts the month name from the date cell.
when I use Excel to make some data analysis: Excel recognizes that the column contains a month name so when I create a chart or a slicer it sorts the months chronologically (January, February, March, ,...)
When I tried to use Power BI to create a chart for the same table, Power BI doesn't recognize that the column contains month names and it sorts them alphabetecally (April, February, January,....) or sometimes in unlogical order.
is there a solution for this?
Many thanks in advance.
Solved! Go to Solution.
Hey,
you have to order the column with the month names by a column that contain 1 for January, 2 for February and so on
maybe this will get you startet
You alsoi may try the search "Month" and "Order"
Hope this helps
Hi @AbdullahTammour,
Have you tried the solution provided by @TomMartens above? It should work in your scenario.
If it works, Could you accept it as solution to close this thread? If you still have any question on this issue, feel free to post here.
Regards
Hi @AbdullahTammour,
Have you tried the solution provided by @TomMartens above? It should work in your scenario.
If it works, Could you accept it as solution to close this thread? If you still have any question on this issue, feel free to post here.
Regards
Hey,
you have to order the column with the month names by a column that contain 1 for January, 2 for February and so on
maybe this will get you startet
You alsoi may try the search "Month" and "Order"
Hope this helps
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |