How to Display KPI Icons in a PivotTable
Which KPI field should you add to a PivotTable if you want to display the KPI icon?
A. Status
B. Goal
C. Measure
Where do you create KPI's in the Data Model?
A. By selecting Create KPI from the Diagram View
B. By right-clicking on the base value (measure) in the calculation area and selecting Create KPI
C. By right-clicking on the column name on the Data View and selecting Create KPI
D. By right-clicking on the base value (measure) on the Pivot Table and selecting Create KPI
Answer:
To display the KPI icon in a PivotTable, you should add the "Status" field.
To create KPI's in the Data Model, you need to right-click on the base value (measure) in the calculation area and select Create KPI.
Displaying KPI icons in a PivotTable can provide valuable insights into your data and its performance. By adding the "Status" field to the PivotTable, you can visualize the status of Key Performance Indicators (KPIs) using icons.
When creating KPIs in the Data Model, it is essential to right-click on the base value (measure) in the calculation area. This allows you to define the target value, actual value, and other parameters to set up the KPI effectively.
By following these steps, you can easily enhance your data analysis capabilities and make informed decisions based on KPI data.