Forum Discussion
Helper VRearrange the Slicer Texts
Hello,
Can some one tell me how to rearrange the slicer texts in the box.
The below is the case where i want the G360,GPA,TMT,Buil ect.. to be re arranged.
Not sure if this can be done.
Regards,
Ranjan
hi, RanjanThammaiah
Yes, you could use Sort by column in Power BI Desktop
For example:
Add a column
if ([Column]="G360" , 1,
if ([Column]="GPA" , 2,
if ([Column]="TMT" , 3,
if ([Column]="Built" , 4,
if ([Column]="NZ Div Bus" , 5))))
Then sort by the new column.
BeforeAfter
Best Regards,
Lin
1 Reply
v-lili6-msftCommunity Support
hi, RanjanThammaiah
Yes, you could use Sort by column in Power BI Desktop
For example:
Add a column
if ([Column]="G360" , 1,
if ([Column]="GPA" , 2,
if ([Column]="TMT" , 3,
if ([Column]="Built" , 4,
if ([Column]="NZ Div Bus" , 5))))
Then sort by the new column.
BeforeAfter
Best Regards,
Lin