Starry Filter

First, we are going to generate some sample data using an INLINE load. Let’s also add some stars to represent the ratings using the repeat() function:

Ratings:
LOAD *, Repeat('★', Rating) as [Stars rating] INLINE [
Rating, Reviewer
5, Presley Coates
5, Alessia Goodwin
5, Alec Keith
5, Ellis Webster
4, Katy Mccormack
4, Brielle Glass
3, Vanessa Bouvet
2, Keanan Cousins
2, Kelise Hamer
1, Allen Grimes
1, Antonina Bentley
1, Pheobe Hawes
];

Filter Setup

Now, we will create 5 button charts triggering specific selections in the Rating field. We will also alternate the ★ and ☆ symbols based on values selected. But don’t get nervous, let me explain it step by step:

1. Create a new variable called vColorStars.

=If(GetSelectedCount([Rating]) = 1, GetFieldSelections([Rating]), 0)

2. Create a button object.

3. Go to Actions and navigation > Add Action > Select values in a field. In Field, select Rating and in Value type =1.

4. Next step: go to Appearance > General > Label and type this:

=If($(vColorStars) >= 1, ‘★’, ‘☆’)

5. Now, go to Appearance > Font styling > Font color and choose any color you like (or simply select By expression and use =’#e9c46a’ if you want to keep the classic yellow stars.

6. Finally, go to Appearance > Background and change the color once more. If you want to use a transparent background, just type =ARGB(0,0,0,0).

We just created our first object, which will select all 1-star ratings. Go ahead and copy this object 4 more times. Just change the 1 from step 3 and 4 to 2, 3, 4 and 5 for the rest of the buttons. 

Hopefully, everything went well and you now have your own starry filter. Nice!