Forum Discussion
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!
Hi AniketMS ,
I think the solution provided in this ticket might be helpful in your case: https://community.fabric.microsoft.com/t5/Desktop/dynamic-sort-by-measure-filter/td-p/1345032
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution โ๏ธ or giving it a kudoe ๐
Thanks!
Best regards,
Joao Ribeiro
1 Reply
- joaoribeiroImpactful Individual
Hi AniketMS ,
I think the solution provided in this ticket might be helpful in your case: https://community.fabric.microsoft.com/t5/Desktop/dynamic-sort-by-measure-filter/td-p/1345032
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution โ๏ธ or giving it a kudoe ๐
Thanks!
Best regards,
Joao Ribeiro