A data annotation (measure correction) is a change to a measure value in a metric set, which is then also marked with a comment in visualizations like a regular note or annotation. The measure correction can be made public if the original value was incorrect, or it can be kept private for your own use for analysis or what-if scenarios and then removed.
Since a note is associated with data, the same correction will automatically apply to other data visualizations or views that are displaying the same data from the same metric set.
2. Make a data annotation
First, create a dashboard. For example, from the [Sales].[SalesOrderDetail] table of the Adventure Works database, drop LineTotal onto the canvas and ProductID onto the Rows field of the Data Analysis Panel.
The resulting visualization will be a Data Bar Table. Drop a Product hierarchy onto the ProductID row to promote it.
Switch to View mode.
Right-click the Clothing data bar to open the context menu and select Correct Value.
The Measure Value bar appears below the main toolbar. This is where you enter a new value for the selected measure.
If the correction is for your own analysis or a what-if scenario, click the unlocked padlock labeled public to change it to a private data annotation.
Click advanced if you want to include a comment for this correction.
Click apply to add the correction.
The value correction is applied to the actual data and visualized, but also marked with a note. Hover over the note to see its details in a Note popup window.
Finally, right click over the table and click Re-Visualize. Then click Bar. You will see the note that was added to the Clothing value. Hover over the note to see the details.
This shows that the note is associated with the data rather than a specific visualization.
3. Change the correction
Other users who have permissions to view the same dashboard can also change the correction.
For example, as a different user, hover over an existing note to open its Note window. Click the menu button in the bottom right corner. Then click Change Value.
The Measure Value bar appears below the main toolbar. Enter the revised correction, and then click apply.
The value correction is applied to the data and the note is updated. Hover over the note to see its details.
4. Delete a correction
To delete a correction, hover over it to open its Note window. Click the menu button in the bottom right corner. From the menu, select Delete.
5. Prevent corrections
Users require the Correct Measure Values privilege to be able to create data annotations or correct measure values.
By default, data annotations are enabled for all measures for users that are allowed to correct measures, but you can prevent users from making corrections to a specific measure.
From the Data Analysis Panel, edit the measure.
In the Configure Metric Set Element dialog, uncheck the option Allow Data Corrections.
- Data annotations are not supported for dynamic measures, function-generated hierarchies, or on metric sets with dynamic hierarchies.
- Data annotations are not applied to measure values displayed using the Collapse All option or when expanding hierarchy members.
- Data annotations are not affected by the check in or check out state of the metric set. Undo Check Out does not change or remove the applied corrections.
- Contextual measures that are checked out to you are changed directly, rather than a data annotation created on top of it.
- When working with OLAP data, the values for totals and the grand total are taken directly from the OLAP source and will not be affected by data annotations.