Forum Discussion
sorting a slicer based on another column
hello!
So I have this sclicer that shows the restaurants. and I also have another slicer with the ratings and another with rating count.
I have everything set, but what troubles me is that the restaurant name slicer is sorted from a-z. I want it to be sorted based on the ratings from 5-1, and the ratings let's say 5 , is sorted by the rating count. So the restaurant slicer is beginning with 5 stars with most rating count to the least then goes to 4 stars from the most rating count to the least ans so on. is that possible?
these are the columns:
and these are the slicers:
5 Replies
create a new column = 5 - [Rating]
and sort the name of the restaurant by itsorry I'm new. How to sort it by it? from where?
ok got it. I did sort it by the rating column but it gives this error message
yes, sorry it should be like that, you have a lot of names that have the same rating
I suggest adding a new column to the matrix, and sorting by it, and of course hiding it so that it is not visiblesorry I don't get it. what should be in the new column. please i will accept any solution. just explain to me slowly 😛
