Skip to main content

Power BI

Completed

Star Rating Visualization

Vote (35) Share
Jake Carville's profile image

Jake Carville on 07 Jan 2016 17:27:04

It would be brilliant to have a star rating visualization to show ratings on a set scale, possibly from 0-5, or even 10. It would be similar to the rating system on amazon, and would be a great way to display quality metrics.

Comments (19)
Jake Carville's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:15:28

RE: Star Rating Visualization

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? :)

Jake Carville's profile image Profile Picture

52b5cce4 5162-45fc-a468-4609777326e8 on 05 Jul 2020 22:15:28

RE: Star Rating Visualization

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.

Jake Carville's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:15:16

RE: Star Rating Visualization

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.

Jake Carville's profile image Profile Picture

52b5cce4 5162-45fc-a468-4609777326e8 on 05 Jul 2020 22:14:55

RE: Star Rating Visualization

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

Jake Carville's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:14:55

RE: Star Rating Visualization

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

Jake Carville's profile image Profile Picture

52b5cce4 5162-45fc-a468-4609777326e8 on 05 Jul 2020 22:14:55

RE: Star Rating Visualization

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.

Jake Carville's profile image Profile Picture

1f7f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:14:55

RE: Star Rating Visualization

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).

Jake Carville's profile image Profile Picture

24d1dacc 3327-408d-a4f2-a576791414af on 05 Jul 2020 22:14:17

RE: Star Rating Visualization

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

Jake Carville's profile image Profile Picture

32ec86a6 8bb0-4389-acd5-656b4e58c13f on 05 Jul 2020 22:13:17

RE: Star Rating Visualization

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