如何在power bi中按矩阵的降序对列日期进行排序 [英] how to sort column dates in descending order of matrix in 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:

这篇关于如何在power bi中按矩阵的降序对列日期进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！