如何在power bi中按矩阵的降序对列日期进行排序

本文介绍了如何在power bi中按矩阵的降序对列日期进行排序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我需要按日期的降序对我的矩阵列进行排序.我有什么选择吗?检查这张

您可以使用它对矩阵进行排序 - 选择它，单击字段窗格中的日期列，单击

这将颠倒矩阵中列标题的顺序:

I need to sort my column of matrix in decreasing order of dates. I there any option? check this image of matrix I need to order from Jan-20 to Jan-19(this column is already sorted with dates column). Thanks in advance.

解决方案

One solution is to add a new column to define the search order in the way you want, in this case by date descending. So if you add a custom column in your model like this:

You can use it to sort your matrix - select it, click your date column in the fields pane, click Sort by Column button in Modeling tab and select the newly added column:

This will reverse the order of the column headers in the matrix: