Forum Discussion

SumantShekhar's avatar
SumantShekhar
Frequent Visitor
8 years ago

sort multiple columns

HI, I am rendring Table visual, Here I want to sort rows based on three columns, But currently sorting with multiple column is not available. So i tried to concatinate all three columns & created a ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SumantShekhar,

 

As bidevsugmen suggested, you can use the "Sort By" feature. In Query Editor mode, add a custom column (suppose it's Col4) which combines Col1, Col2 and Col3. Based on Col4, please add a conditional column to list the sort order for each value in Col4. Then, in report view, click the Sory By option under Modeling tab in the top ribbon, change default selection to col4.

 

Best regards,

Yuliana Gu