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