For many who have attempted a performance scorecard in Microsoft Power BI, the experience can be frustrating, to put it mildly. Unlike a report used mainly as a research tool, a scorecard is a dashboard designed for minimal user interaction to provide a snapshot over given length of time. Based on the idea of Short Interval Control, if a manager has an easy view of Key Performance Indicators, it will aid the manager in a running Gap Analysis to determine what to improve and what to maintain.
Key Performance Indicators are industry and plant specific, but the share the commonality of being a time series trend of whatever metric is needed to be measured. While formatting a single trend in Power BI is simple enough if the metric is created, a scorecard is a collection of snapshots of multiple trends. Formatting these multiple trendlines can be cumbersome and subject to many aesthetic tweaks.
This is where the magic of sparklines comes into frame. I discovered these add-ons through a Youtube Channel hosted by Power BI vlogger Avi Singh . The channel is a fantastic resource for exploring some of the oddities and options of Power BI.
After researching sparklines in the Power BI applet store, I found a wonderful tool called "Multiple Sparklines", which offers both free and paid options, depending on the tweaks needed by the user. A few of the KPI's included were maintenance performance related, and the others were personnel management related.
After creating the metrics, adding in relative date rage filters, and downloading the applet, it was just a click and drag to add the metrics. The applet offered every graph type available in Power BI and also individual values. The finished product was easy to size and aligned everything to a predefined grid, so aesthetic complains were not an issue.
The finished product displays all the desired metrics and shows no signs of glitches when uploaded to the Power BI service, which can be a problem with aftermarket applets. I have included a link to both Avi Singh's channel and the creator page of Multiple Sparklines. I highly recommend this applet when compiling an SIC or KPI board.
Comentários