Forum Discussion
Sort column Headers in a Matrix
Hi Guys,
Can we control the sorting for the column headers in a matrix ?The row and the column sorting should be done based on other columns (here i ahve created 2 new columns in the data model Employee_Sort and Days_Sort) which are not there in the matrix table.
Here is what i have created in Power BI matrix table :
As you can see from the above the rows and columns are automatically got sorted by alphabetical order.
But i would like to display as below. Is this possible ?
Thanks,
Ravi
12 Replies
Hi grkanth81,
AFAIK, current power bi not support custom order of columns, it only support default sort order. I'd like to suggest you submit an idea for this requirement.
Maybe you can try to add calculate column to modify column with custom prefix string to achieve custom sort order.
Custom Category = VAR _prefix = SWITCH ( [Category], "Not_Applicable", "0_", "0-30 Days", "1_", "31-60 Days", "2_", "61-90 Days", "3_", "91-120 Days", "4_", "120+ Days", "5_", "z_" ) RETURN _prefix & [Category]Regards,
Xiaoxin Sheng
Thanks Xiaoxin Sheng for you reply.
There seems to be other related ideas already requested and i have now voted it
Thanks for your SWITCH suggestion, But when i did in that way the row headers are displaying as below and i don't want to see that starting text 0_, 1_, 2_ etc....and I guess we can't get rid of them while displaying. I am not sure.
Thanks,
Ravi
Hi,
This should be possible. Share the link from where i can download your PBI file.
Hi Ashish,
Thanks for your reply.
Please find the attached pbi file and source data
https://www.dropbox.com/s/n62qnufl5gnw3ru/TEST_Data.pbix?dl=0
https://www.dropbox.com/s/gu0imya50uh58nb/TEST_Data.xlsx?dl=0
Thanks,
Ravi
Thanks for sharing… check out the links below. It provides a comprehensive guide on how to sort measures as columns
in a matrix visual.
https://insurancedatainsights.blog/2024/04/27/dynamic-data-display-matrix/
Unlock Dynamic Data Display In Your Power BI Matrix
