Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am struggling to sort the column in my matrix visual as you can see in below SS-1 there is column sort by alphabetically PQTD, PYTD, QTD, YTD but I want to sort column like this QTD,PQTD,YTD,PYTD
I have also created a helper column to sort matrix column by using this field I can sort but sorting not flowing my matrix visual
Need your help is there any other way sort column so that I can sort the column in matrix visual to get my desire output QTD,PQTD,YTD,PYTD ?
SortPeriod = SWITCH(TRUE(),'Report Period'[Period]="QTD",1,'Report Period'[Period]="PQTD",2,'Report Period'[Period]="YTD",3,'Report Period'[Period]="PYTD",4)
SS-1
SS-2
Thanks
Lavdeep
Solved! Go to Solution.
Hi @lavdeepk ,
First create a new column as below: (to avoid a circular dependency error)
_Period = 'Report Period'[Period]
Then select the column>sort by column>SortPeriod:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@lavdeepk , have you marked it as sort for the period column.
Period - https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
@amitchandak Thanks for reply
I Just go through the link shared your article not relevant because I am using the latest version of power bi desktop where the sort by column option not showing under the modeling tab I just sort additional helper field from data view (Select field +Right Click+ Sort) it works in data view but changes not flowing in visual it remain same alphabetically
@lavdeepk , Can you share a sample pbix after removing sensitive data.
@amitchandak Hi Amit i am sharing sample file link https://1drv.ms/u/s!Apzdvw43zyKGgeAYM-u5sm8xXDtTnw?e=tQ655Q
Thanks
Hi @lavdeepk ,
First create a new column as below: (to avoid a circular dependency error)
_Period = 'Report Period'[Period]
Then select the column>sort by column>SortPeriod:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |