Edit

Import and display KPIs in Power BI

  • Article

With Power BI Desktop, you can import and display KPIs in tables, matrices, and cards.

To import and display KPIs:

  1. Start with an Excel workbook that has a Power Pivot model and KPIs.

  2. Import the Excel workbook into Power BI, by using File -> Import -> Power Query, Power Pivot, Power View. You can also learn how to import workbooks.

  3. After import into Power BI, your KPI will appear in the Fields pane, marked with the traffic light icon. To use a KPI in your report, be sure to expand its contents, exposing the Value, Goal, and Status fields.

    Screenshot of Power BI Desktop showing Delta KPI expanded in Fields pane.

  4. Imported KPIs are best used in standard visualization types, such as the Table type. Power BI also includes the KPI visualization type, which should only be used to create new KPIs.

    Screenshot of Power BI Desktop showing Table1 fields selected in Field pane.

You can use KPIs to highlight trends, progress, or other important indicators.