Visualising ratings data in Power BI

The inspiration for this article comes from the app Webull which is a stock market app for investors which includes real time quotes, financial news, investing advice etc. It is one of the best apps in the market if you are a frequent investor in the stock market. It is an extremely well-designed app with an awesome user interface which makes it a pleasure to use.

 

The visual below is from the app and is the recommended rating for a stock by Wall Street analysts. This is a great visual and you immediately know if the stock is worth buying or not. In this case you are better off holding on to it if you have purchased it or hold off on purchasing till the ratings improve on the stock.

When I first saw this visual I immediately thought of recreating it in Power BI. I created some dummy data on survey ratings for a set of questions for three different cities Brisbane, Melbourne, and Sydney. My data model and relationship looked like this

My first choice of visual was the Bullet Chart. For this I needed to divide my data into bins. Since the ratings are out of 5, I created a new table like the below

My bullet chart looked like this

Which was a good start but not quite like the chart, I had in mind. So I went back to the drawing board and created a new table like the one below

Min and Max remained at 0 and 5 respectively. The other columns were derived as follows

Fair = Max([Value],1)

Satisfactory = Max([Value],2)

Good = Max([Value],3)

Very good = Max([Value],4)

With a little bit of formatting and text I got the chart I was looking for

Link to dashboard here