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 together,
I have a bar chart with date values in the following format: 2020-January, 2020-February...
I want to sort the values with the months in the correct chronological way.
Unfortunately the data is sorted by the name of the regarding month.
Do you have an idea how to solve this?
Thank you and regards,
Andreas
Solved! Go to Solution.
@AndreasSc Create a calculated column to get the month number in the column and then sort the month using the Month Number calculated column.
Snapshot below:
@AndreasSc Create a calculated column to get the month number in the column and then sort the month using the Month Number calculated column.
Snapshot below:
Hi @ghoshabhijeet ,
I understand how to sort it within the data view.
But I don't get it how to do it within the bar chart.
Because I want to show the month names (2020-January, 2020-February...) and sort them via the numeric month.
Can you tell me how to do this?
Thank you and regards,
Andreas
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |