Forum Discussion
Help with a visual
Create a new table using:
Rating Slicer = {"Overall rating", "Food rating", "Service rating"}
Leave this table unrelated in the model.
Create a measure along the lines of:
Selected Parameter = SWITCH(TRUE(),
SELECTEDVALUE(Rating Slicer[Value]) = "Overall rating", [Your overall rating measure],
SELECTEDVALUE(Rating Slicer[Value]) = "Food rating", [Your food rating measure],
[Your service rating measure])
Now create the visual with this [Selected Parameter] measure and a slicer using the field from the Rating Slicer table.
Hi PaulDBrown ,
Thanks for your response. I actually made a similar measure for another visual using the same technique which you suggested. But this time the problem is that Overall, Service and Food Ratings are not measures but columns of my Ratings table. Hence I dont know how to use this.
If you could suggest how should I change this measure so that I can get the column as these are not measures for me would be great! Appreciate your help!
Thanks
Radhika
Can't you just create measures along the lines of:
Overall rating = SUM(Rating[Overall_rating])
?
Sadly no as this is the rating of restaurant out of 3. I want the rating to come as a legend like in the visuals. I want to count the number of restaurants in each city which are given a rating of 0, 1 and 2.
