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
I'm trying to visaulize data from last yoer and current year, but months in my chart are in the wrong order.
Need to be sorted by year also (like this: December January February), but
Example pbix-file here: https://1drv.ms/u/s!ApMveMy2oLCRhJpgk_DTzLKydDxHFg?e=mnBv11
Looks like I need to uncheck something ore enable an option for a correct order, but can't find the solution.
Solved! Go to Solution.
Column = year('Table'[Column1])&FORMAT('Table'[Column1],"mmm")
add the new column to x-axis
Proud to be a Super User!
please try to use yyyy/mm or other column with year value in axis.
Proud to be a Super User!
thank you for your suggestion
I've created a new table to test it, but I'm still seeng the same "wrong" month order
what am I missing?
Column = year('Table'[Column1])&FORMAT('Table'[Column1],"mmm")
add the new column to x-axis
Proud to be a Super User!
got it ryan_mayu
thank you!
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |