Forum Discussion
Solved
Rearrange 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. ...
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
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