在 Power BI 中导入和显示 KPIImport and display KPIs in Power BI

此页面有帮助吗?

借助 Power BI Desktop ,可以导入并显示表、矩阵和卡片中的 KPI。With Power BI Desktop, you can import and display KPIs in tables, matrices, and cards.

按照以下步骤导入并显示 KPI。Follow these steps to import and display KPIs.

  1. 启动具有 Power Pivot 模型和 KPI 的 Excel 工作簿。Start with an Excel workbook that has a Power Pivot model and KPIs. 本练习会使用名为“KPI”的工作簿。 This exercise uses a workbook named KPIs.

  2. 使用“文件”->“导入”->“Excel 工作簿内容” ,将 Excel 工作簿导入到 Power BI 中。Import the Excel workbook into Power BI, using File -> Import -> Excel workbook contents. 也可以 了解如何导入工作簿You can also learn how to import workbooks.

  3. 导入到 Power BI 之后,KPI 将显示在“字段” 窗格中,并标记有交通灯图标。After import into Power BI, your KPI will appear in the Fields pane, marked with the traffic light icon. 若要在报表中使用 KPI,请确保展开其内容,显示“值” 、“目标” 和“状态” 字段。To use a KPI in your report, be sure to expand its contents, exposing the Value, Goal, and Status fields.

  4. 导入的 KPI 最好在标准可视化效果类型中使用,如“表” 类型。Imported KPIs are best used in standard visualization types, such as the Table type. Power BI 还包括“KPI” 可视化效果类型,应仅用于创建新的 KPI。Power BI also includes the KPI visualization type, which should only be used to create new KPIs.

以上是其中包含的全部内容。That's all there is to it. KPI 可用于突出显示趋势、进度或其他重要指标。You can use KPIs to highlight trends, progress, or other important indicators.