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.
is it possible to sort a pivot chart by column?
I just can higligh by clicking on them...
If not, any workaround?
Solved! Go to Solution.
Hi @Anonymous ,
I have built a data sample. And according to my understanding, you may want to sort by X or Y or Z (Column Field) in matrix visual, right?
Currently, it could easily sort by Category(Row Field)or Sub-Total in matrix as you seen, only these two fields has sort icon:
In this case, you could replace the sub-total value by a measure to reach your requirement. Let's take how to sort by Y as an example:
1. Create a measure for Y sum:
Y Sum = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category]) && 'Table'[Sub-Type]="Y"))
2. Use HASONEVALUE() , ISINCOPE() to change the sub-total value and use rank number to sort the Y sum :
Sory by Y = IF(HASONEVALUE('Table'[Sub-Type]),SUM('Table'[Value]), IF(ISINSCOPE('Table'[Category]),RANKX(ALLSELECTED('Table'),[Y Sum],,ASC,Dense)))
The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I have built a data sample. And according to my understanding, you may want to sort by X or Y or Z (Column Field) in matrix visual, right?
Currently, it could easily sort by Category(Row Field)or Sub-Total in matrix as you seen, only these two fields has sort icon:
In this case, you could replace the sub-total value by a measure to reach your requirement. Let's take how to sort by Y as an example:
1. Create a measure for Y sum:
Y Sum = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category]) && 'Table'[Sub-Type]="Y"))
2. Use HASONEVALUE() , ISINCOPE() to change the sub-total value and use rank number to sort the Y sum :
Sory by Y = IF(HASONEVALUE('Table'[Sub-Type]),SUM('Table'[Value]), IF(ISINSCOPE('Table'[Category]),RANKX(ALLSELECTED('Table'),[Y Sum],,ASC,Dense)))
The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I think some screenshots and samples of the data and what are you trying to acheive would do great in understanding what are you after.
Regards
H
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |