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,
can someone please tell me how to sort the years in the different columns (see picture)?
I want the first column to say 2021, the second column 2020 and the third column 2019.
Thanks
Solved! Go to Solution.
Hello @DagdasAlbag ,
You need to sort the year column in your data in descending order.
If you still see issue, consider adding a conditional column in your data and use the sort by column option to order is according to your need.
Refer https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can also refer this
Hi @DagdasAlbag
You can enter a table 'SortTable' with Year and SortOrder columns. SortOrder values are based on Year values descendingly. Sort Year column by SortOrder column.
Then create a relationship between SortTable and Original Table on Year column.
At last, select SortTable's Year column into the matrix.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @DagdasAlbag
Has the problem been solved? If so, you may accept the appropriate post as the solution or post your own solution to help other members find it quickly. If you are still confused about it, please provide more details about your problem. Thanks.
Regards,
Community Support Team _ Jing
Hi @DagdasAlbag
You can enter a table 'SortTable' with Year and SortOrder columns. SortOrder values are based on Year values descendingly. Sort Year column by SortOrder column.
Then create a relationship between SortTable and Original Table on Year column.
At last, select SortTable's Year column into the matrix.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hello @DagdasAlbag ,
You need to sort the year column in your data in descending order.
If you still see issue, consider adding a conditional column in your data and use the sort by column option to order is according to your need.
Refer https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can also refer this
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |