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,
I have a dashboard with tables and charts in my visualization which are connected to a table which has seperate columns for months and years. the months are indicated as numbers.
I had the months of 9, 10, 11, 12 of 2018 and now am adding also 1 of 2019 which is now causing me issues with sorting as this january comes first.
in my table and charts I add the month into the visualization and sort by it. then I tried to add the year field into the tooltip and sort by it (as a secondary sort)... this doesn't work
I hope someone here could have a better idea for me
Solved! Go to Solution.
Hi @Allav,
I don't think so it is possible to break an order of an axis. An axis is always ascending or descending, but you expect, that there are for example 10, 11, 12, 1, 2, 3, ...
What you can do, is to create a new column with a format like yyyy-MM (e.g. 2019-02) and use it as your axis. Then the values will always go up.
Hi @Allav,
I don't think so it is possible to break an order of an axis. An axis is always ascending or descending, but you expect, that there are for example 10, 11, 12, 1, 2, 3, ...
What you can do, is to create a new column with a format like yyyy-MM (e.g. 2019-02) and use it as your axis. Then the values will always go up.
Thanks, after trying few different options I think that your sugestion is the only way to go about it. I could not find a way to do sorting by 2 fields.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |