Balanced Scorecard - A better way?

[JCA]

Hi All,

I am trying to build a Balanced Scorecard that shows month on month information and vairances.

I have tried using a Matrix, Power Matrix and a solution using a table as a reference (https://medium.com/microsoft-power-bi/scorecard-in-power-bi-c2fee459f717)

The issue I find is the Matrix doesn't look right; Power Matrix is complex but again provides limited visuals

The link above does do what I want but is mantanance heavy.

I could do somthing with Cards but this will naturally effect performance as I want to display 20 or 30 KPIS and be equally heavy on mantainance. 

Does anyone know of a better visualisation or method?

JC

[v-jianpeng-msft]

Hi, @JCA 

You can create metric visuals in Power BI reports. Deep integration of metrics and scorecards into reporting solutions is a great way to drive team alignment and progress. New or existing scorecards and metrics can be seamlessly integrated into reports and even updated directly in Power BI Desktop.The photo below shows the Metrics display and comes with a link to the official documentation for the configuration.:

Create a metrics visual in a Power BI report - Power BI | Microsoft Learn

In addition, you can find the visual objects you want from Power BI visuals and download their sample files for viewing.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JCA]

Thanks V,

The Scorecard function will not work with my current architecture as I am using power BI embedded for external users.

I think the issue is actually my warehouse not being configured to use the Power KPI matrix visual so I will need to write a subquery to bring the data in correctly.

JC

[v-jianpeng-msft]

Hi, @JCA 

Thank you very much for your reply and I am very sorry for my late reply. Have you found a suitable solution and can you see if PowerBI Scorecards 101 is right for your needs? Here's where this Scorecards can be used:

PowerBI Scorecards 101: everything you need to start - dev>scope (devscopewp.azurewebsites.net)

This is a third-party maintained Scorecard, You need to learn more about it before you decide whether to use it or not.

Best Regards

Jianpeng Li