Saving KPI targets

Hi PaulusD ,

1. One way to do this is to use the Power KPI Matrix visual object, which is a customized visual object that can be downloaded from the Marketplace. This visual object allows you to display multiple KPIs in a matrix format, each with indicators, trends, and targets.

Refer : How to Use Power Kpi Matrix in Power BI - Zebra BI
2. Another way is to create scorecards and manual metrics in Power BI.

Refer: Create scorecards and manual metrics - Power BI | Microsoft Learn
3. A third method is to use the KPI Visual Object in Power BI to display each KPI with its target and actual values.

Refer : Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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

Hi PaulusD ,

At my company, we often run into situations where there are data elements that need to be changed semi-regularly, KPI targets or goals is a great example. As we want our data team focused on development, we don't want them bogged down with regular maintenance of reports to update hard-coded target values and such. We want the business owners/stakeholders responsible for setting the targets to be able to update them as they wish, without having to bother the data team. We just created a Sharepoint site, and set up specific use-case Sharepoint Lists. For your example, we would set up a Sharepoint List on that site called "KPI Targets." Within the list, you would have data elements like KPI ID, KPI Name, Effective From Date, Effective To Date, KPI Target Value, and any additional things you'd want, e.g. target change comments or whatever. We then grant edit permissions to this Sharepoint List to the business stakeholders and teach them how to enter/change KPI targets. In our PBI reports, we connect to this as a datasource, and from there we can use it in our model so that when the values change, the PBI reports automatically reflect the changes. I'm sure there are many ways you can address this requirement, but this works for us. Hope this helps!