Itโs been 6 months since we released the preview of Power BI goals and weโre excited to announce a new set of features to help you take Power BI goals to the next level of use in your organization!
These new features include goal level permissions, Power Automate integration with goals, and a new scorecard visual that can be added to Power BI reports. Weโve also added several top requested user experience enhancements for moving goals within a scorecard and showing/hiding scorecard fields.
Since the initial preview release of goals itโs been amazing to learn about how organizations are using goals to help grow their data culture. Weโve heard how creating scorecards and assigning goals is helping teams work towards clear and measurableย objectives, how goals are helping to drive the use of data to track progress on key metrics, and how the ability to โcheck-inโ on goals and provide status is helping improve how owners and stakeholders collaborate and stay aligned. Based on this usage and your feedback we believe this new round of features will help you deploy goals even more broadly and integrate them more fully into all of your key business processes.
New Scorecard Visual (Preview)
Integrating goals and scorecards deeply into reporting solutions is a great way to help drive alignment and progress on a team. To make this easy weโre adding a new scorecard visual which can be added to Power BI reports. When included in a report, this visual enables users to see the entire scorecard and even make updates to their goals in the context of the report.
Goals can also now be created directly from within Power BI desktop using the visual, streamlining how they are created and managed. The visual supports various formatting options for scorecards, ranging from font style, colors to backgrounds, so users can customize existing scorecards however they like it to fit the look and feel of the rest of their report.
This new scorecard visual is the first step weโre taking to help you integrate goals into your reports. Weโre going to continue to expand and improve on Goals visualization and are looking forward to using your feedback to guide us.
Goal level permissions
In many organizations,ย different rolesย need different types of permissions to specific goals. For example,ย maybeย onlyย managersย should seeย goalsย related to human resources and finances, while all employees can view goals related to operations.ย Further, perhaps only certain individuals should be able to edit or update a goal while other groups should only have view access. Now, with goal level permissions, you can support these scenarios where different users need different levels of access for specific goals.
Youโll find the goal level permissions settings in the permissions tab of the scorecard settings pane. Here you canย create roles withย differentย sets of permission and assign these roles toย specific user groups.
Here are theย different typesย of permissions we support:
- View permission grant access for users to view specified goals within a scorecard
- Update permissions allow users to update specific aspects of a goal.ย To further control how users interact with a goal there are a few options available under update permissions (and any combination of the following can be selected)
- Noteย โ allows users to add notes to a goal
- Statusย โ lets a user update status for a goal
- Currentย Valueย –ย grants the ability to update the current value for a goal.
To make it easy to set these permissions across goals in your scorecard you can use the “apply to all” option or turn onโฏan inheritance option so all existing andย future subgoals under that level inherit the permissions of the parent.
Another useful goal level permissions feature is enabling a “default” permission modelย that’sย applied to anyone without specific permissions assigned who accesses the scorecard.ย ย Youย can create a role with any combination of permissionsย youย choose, and make that the default permissions, ensuring that any time anyone lands on the scorecard,ย theyโreย seeing exactly what the scorecard author selects.
Powerย Automate Integration
Power Automate provides an amazing set of capabilities to create no-code automation to streamline tasks across a huge variety of SaaS experiences. With new Power BI goals integration with Power Automate we canโt wait to see the ways people directly drive action based on changes to goals or update goals based on events in other systems.
Weโve made it easy to get started by launching Power Automate directly from your scorecard so you can immediately construct your automated flows. Here are the triggers and actions enabled within Power Automate:
Triggers:
- When aย goalย changesย (e.g., status, owner, etc.)
- When someone adds or edits a check-in
- When an owner is assigned to a goal
- When a data refresh for a goal fails
Actions:
- Createย a goal
- Create a check-in
- Add a note to a check in
- Create a scorecard
- Update a check-in
- Update a goal
- Getย goal(s)
- Getย goal check-in(s)
In addition toย theseย actions and triggers,ย newย templates will be rolling out within the next few weeks that allow you to start from a flow showing you how to complete different business scenarios and giving you the building blocks you need to automate your process.ย A sneakย peakย at just a few of the scenarios we’re providing templates for:
- Triggering aย Teamsย notification when a status changes to โbehindโ or “at risk”
- Sending reminders to team members at a specified interval with a link to a scorecard or specific goals to review
- Notifying aย specificย team member when they are assigned to a new goalย and should perform a check-in
- Sending a forms survey that gets added as a check-inย noteย on a goal at a specified interval
- Sendingย a congratulations email when a team completes a goal
Using Power Automate with your Power BI goals helps yourย teams and organization respond more quicklyย to changing conditions, and to easily use data to take better actions.
ย Moving goals around your scorecard
We understand that things change within an organization and the placement of a goal within the scorecard matters. Now you can drag and drop goals around your scorecard, making it easier than ever to create an accurate view ofย yourย organization’sย priorities and goal groupings.
Showing/hiding and moving columns
When creating a scorecard that is right for your organization you may want to have users focus on specific attributes of a goal. With this release, weย are enabling the ability to hide/showย columns in the scorecard to give you control over what is shown.ย Additionally, scorecardย authorsย will also be able re-order theย columns,ย so the scorecard is best optimized for its audience.
To do this, in edit mode, simplyย click the arrow icon next toย a columnย and open column settings.ย Here youโll be able to specify which columns you want shown or hidden. You can also drag the column names up or down to reorder them on the scorecard.
Aligning goals to dataset hierarchies
If you tuned in for the Ignite Goals session, you saw a sneak peak of an upcoming feature that let you align your goals to dataset hierarchies.ย This feature enables users to โslice and diceโ a scorecard based on a pre-determined hierarchy so they can understand progress to goals for specific parts of the business โ without the need to manually create a specific goal for every item at every level of a hierarchy. This is key for supporting unified scorecards that span large organizations or business processes. Weโre still putting the final touches on this feature, but wanted to show you whatโs coming.
Between the features shipping during Ignite (which are rolling out world-wide and will be available everywhere soon) and the upcoming hierarchies feature we believe Power BI goals is ready to be integrated deeply into the fabric of your organization, at every level of the business, and with every business process.
We canโt wait to hear your feedback and continue to help you drive a data culture.