Add the sorting function for the header of the pivot table (i.e., matrix) and the function to download as an Excel file in the pivot table format.

[fbcideas_migusr]

Suggestion 1: Add the sorting function for the header of the pivot table (i.e., matrix). When using the pivot table (i.e., matrix) chart in PowerBI, there is often a need to sort the headers (including row headers and column headers). The sorting can be based on the header fields themselves or on the values. The pivot table in Excel has a very flexible header sorting function, while PowerBI lacks this feature. This is a very commonly used function. Without it, we often have to download the data locally and then process it again in Excel, which is very inefficient. This also leads to the second suggestion.

Suggestion 2: Add the function to download as an Excel file in the pivot table format. Currently, when directly clicking "Export Data" in the upper right corner of the chart, only the CSV format can be selected, and the format of the pivot table itself cannot be retained. This means that after downloading the data, we have to generate a pivot table again in Excel, which is rather troublesome. This is the first problem. The second problem is more serious. Some values will be summarized incorrectly when generating a pivot table in Excel. For example, for percentages, they will be directly summed up during summarization, resulting in data errors. Therefore, it is suggested that PowerBI can support the function of directly downloading as an Excel file in the pivot table format.