The standard Key Performance Indicator (KPI) visual in Power BI Desktop compares an indicator measure relative to a Target measure. The variance between the indicator and the target is displayed in the visual and is used to drive the color formatting (for example, red = bad; green = good). For many measures, a corresponding target measure may need to be created that applies some calculation logic to an existing measure. The following measure is simply 10% greater than the previous year's year-to-date net sales:
Target: 10% Above PY YTD Internet Sales = [Internet Net Sales (PY YTD)] * 1.10
In a standard KPI visual, the target measure is displayed as the goal and used to calculate the variance percentage between the indicator and ...