Star Rating Visualization

I would give this idea 5/5 stars if I could.

Hi Jake, I decided to look into how to create a custom visual for Power BI and I think this would be a nice first project. However the first thing that came to mind is, how interactive would it be? As you know, visuals on Power BI are interactive in a way that if you click on a slice of a visual, it highlights the related data in the other visuals (slice and dice). Thing is, how would that work with a star visual? When I think of a star visual, the first thing that comes to my mind is that these are KPIs and not necessarily interactive for slicing and dicing data. What are your thoughts on these? Also the first thing that comes to my mind as a data input for stars are measures, or a rollup of values. Similar to a non-multirow card. Does that make sense? What are your general thoughts on this? PS: When I meant "easily done as a custom visual", bear in mind that easily is subjective. I know how to do something like that quite easy using CSS -- but making that work with Power BI is a different thing. I still think it might be fairly straightforward for a Jscript guru (not me -- but I am giving it a shot).

This is a nice idea, but it can be easily done as a custom visual :)

Hey Pedro, Wow that would be great if you were willing to give this a shot! In terms of interactivity, I would agree with yourself that it would be non-interactive. Obviously if you hover over it, it will give you the exact value e.g. 4.7 / 5. Some people might just want a nice clear non interactive visual on a dashboard as well as interactive visuals so this could strike a nice balance. I was thinking of just inputting a percentage value and then being able to set the scale(in the format options) out of either 5 or 10 stars. So 80% would give you 4/5 or 8/10 depending on the scale you choose. Anything really is much appreciated, I had a run of CSS back in University but it just wasn't for me.

I've never truly understood how GitHub works so I've been apprehensive to even try and create this.

Agree. Can be also a KPI or something like that.

Hi Jake, I am worried about expectations, though. This task has been identified as low priority here at work and I really don't know when I would be able to look fully into it (I'm sorry!) :( -- I am hoping that perhaps others could collaborate with me on a Github for this one? Any takers? :)

Hi Pedro, You're absolutely right about it being a KPI, that's a more straight forward way of putting it. You make some interesting points about the Min/Max scale, it could be a lot more user friendly than my suggested % method, I like it. I'm really interested to see how this works out.

I think that we're missing some fundamentals, to be honest. Say that the visual will show as a star the value of a measure. The measure shows 835. How do we specify that 835 is either 1, 2, 3, 4 or 5 stars? So, in the end, this is really a KPI, isn't it? I think users would have to specify the expected min/max values in the visual settings. So if the ratting goes from 0 to 9000 and you have 5 stars or 10 stars, the visual would know how to render 835 in the star rating.

Hi again Pedro, I have to say that is a nice formula that you have put together that works beautifully to automate a Star Rating type chart, many thanks. Originally I was importing an image manually but this is a lot more streamlined and a big step up so thank you. I have found the Power BI community to be very creative and helpful. Regards, Jake