Visualising ratings data in Power BI

September 8, 2018

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

 

 

This post was first published on LinkedIn on 07/05/2018  here

 

 

 

 

 

 

Please reload

Recent Posts

Please reload

Archive

Please reload

Tags

Please reload