Forum Discussion

AniketMS's avatar
AniketMS
Frequent Visitor
2 years ago
Solved

Sort column in table visual depending on the slicer selection

Hi , 

 

I have a table visual and a slicer , Slicer has three Measures for selction eg : Sales , Revenue , Gross Sales . 

 

In the table we show Cutomer Id , Customer Name , CUstomer Region . when user selects Sales we show sales in descending order and the respective Revenue and Gross Sales . 

 

Now the requirement is when users select Revenue in the slicer the table should be sorted on the basis of Review in Descending order and show the list of customers . and show the Sales and Gross sales respectively. 

 

We are using field parameters and have achived this , but the dynamic sorted on user selection is getting diffcult to achive . 

 

Any guidance will be helpful.

 

Thanks!

 

1 Reply