Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sort by Index

Hello,i have data with three Columns: "Index, Column Name and Value" and repeated data in Columns: Column Name and Value. and need to display data in table with columns "Column Name and Value o...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Anonymous 

 

To use 'sort by column' function, you must ensure that there are no duplicate values in the column.

If you only put 'Column Name' and 'Value' column in table visual, It can only display unique combination values.

Just like in your screenshot, only 2 rows will remain at the end. You must put the index column on it to display all the duplicate values. Then you can sort by index directly in visual.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  ,

 

First of all thanks for your reply

 

We can do sort by index column by adding index column

But i don't want to display index column in table on report

Could you please post better solution