Create linked metrics in the Power BI service (preview)
APPLIES TO: Power BI Desktop Power BI service
With linked metrics, you can show the same metric on multiple scorecards, across multiple workspaces. All check-ins, edits, and updates are reflected in all the metric locations, so you don't have to create duplicate metrics to track the same thing. For example, in many organizations, the leadership team has a scorecard, and each department has its own scorecard with metrics from the leadership team, along with other metrics that are relevant to their department. With this feature, you can now link such metrics to any number of scorecards and get them to be in sync automatically.
If you link multiple metrics at once, the parent-child relationships and the metrics’ order from the source scorecard are preserved in the destination scorecard. And you can use the Set For All option to apply permissions to descendant metrics on the source scorecard, even if there are linked metrics in between the parent and descendants.
Permissions
Say you have build access to a scorecard, meaning you can build content with the data associated with the scorecard. You can link metrics from that scorecard to any scorecards you have edit access to. Only users who have view access to the source metric can see the linked metric.
Create a linked metric
Open a scorecard and select Edit
Select the New button.
Select Link to existing metric (preview).
Select the scorecard that contains the metric you’d like to link from the list provided.
Select the metric(s) you’d like to include in this scorecard.
Select Continue. The linked metric(s) appear on this scorecard.
Check-in and edit a linked metric
You can add check-ins right from the linked metric if you have permission to check in on the source metric. Check-ins are reflected in all scorecards that contain the linked metric and source metric.
You can make edits only in the source metric. You can navigate from the linked metric to the source metric. Select Go to source metric from the overflow menu of the linked metric.
Edits are reflected in all scorecards that contain the linked metric.
Linked metric details
You can see the name and link to the source scorecard in the Details pane.
You can also see this information in the Connections pane.
Linked metrics considerations
Linked metrics and hierarchies
If you filter your scorecard by a hierarchy, linked metrics aren't filtered. They continue showing their original value. Check-ins to linked metrics aren't allowed on a hierarchical child scorecard.
Linked metrics and rollups
If you link a rollup metric onto a different scorecard, it continues to show its calculated value from the source scorecard and doesn't take into account any child metrics on the destination scorecard. Additionally, if a linked metric is the child of a rollup metric, the linked metric isn't included in the parent's calculation.
Related content
- Get started with metrics in Power BI
- Create scorecards and manual metrics in Power BI
- Create connected metrics in Power BI
More questions? Try the Power BI Community.