使用 Power BI Desktop (預覽) 中的深入解析Use insights in Power BI Desktop (Preview)

您可以要求 Power BI Desktop 說明圖表中的增減情況,並取得快速、自動化、具洞察力的資料分析。You can tell Power BI Desktop to explain increases or decreases in charts, and get fast, automated, insightful analysis about your data. 只要以滑鼠右鍵按一下資料點,然後選取 [分析] > [說明減少的情形] (如果之前的橫條圖較低的話,則為增加情形),即會以便於使用的視窗形式將深入解析傳遞給您。Simply right-click on a data point, and select Analyze > Explain the decrease (or increase, if the previous bar was lower), and insight is delivered to you in an easy-to-use window.

這項深入解析的功能與內容相關,並會以正前方的資料點為依據,例如之前的橫條圖或資料行。The insights feature is contextual, and is based on the immediately previous data point - such as the previous bar, or column.


這項功能目前處於預覽狀態,並可能有所變更。This feature is in preview, and is subject to change. 自 2017 年 9 月起的 Power BI Desktop 版本開始,深入解析功能即預設為啟用 (您不需要勾選 [預覽] 方塊即可啟用)。The insight feature is enabled and on by default (you don't need to check a Preview box to enable it) beginning with the September 2017 version of Power BI Desktop.

使用深入解析Using insights

若要使用深入解析,只要以滑鼠右鍵按一下橫條圖或線條視覺效果中的任何資料點,然後選取 [分析] > [說明增加的情形]\ (或 [說明減少的情形],因為所有深入解析都是以先前的資料點變更為依據)。To use insights, just right-click on any data point in a bar or line visual, and select Analyze > Explain the increase (or Explain the decrease, since all insights are based on the change from the previous data point).

Power BI Desktop 即會對這項資料執行機器學習演算法,並於視窗中填入視覺效果與描述,以說明哪些類別對增加或減少情況的影響最大。Power BI Desktop then runs its machine learning algorithms over the data, and populates a window with a visual and a description that describes which categories most influenced the increase or decrease. 深入解析預設會有「瀑布圖」視覺效果,如下圖所示。By default, insights are provided as a waterfall visual, as shown in the following image.

選取瀑布圖視覺效果底部的小圖示,即可選擇要讓深入解析顯示散佈圖、堆疊直條圖,或功能區圖表。By selecting the small icons at the bottom of the waterfall visual, you can choose to have insights display a scatter chart, stacked column chart, or a ribbon chart.

頁面頂端有「喜歡」和「不喜歡」圖示,可讓您提供視覺效果和功能的意見反應。The thumbs up and thumbs down icons at the top of the page are provided so you can provide feedback about the visual and the feature.

值得注意的是,視覺效果頂端的 + 按鈕可讓您將選取的視覺效果新增至報表,就像您手動建立視覺效果一樣。And importantly, the + button at the top of the visual lets you add the selected visual to your report, just as if you created the visual manually. 然後,您可以設定新增視覺效果的格式或進行調整,方法即如您在報表上對任何其他視覺效果的操作。You can then format or otherwise adjust the added visual just as you would to any other visual on your report. Power BI Desktop 中編輯報表時,您只能新增選取的深入解析視覺效果。You can only add a selected insight visual when you're editing a report in Power BI Desktop.

當報表在閱讀模式或編輯模式中時,您都可以使用深入解析,讓分析資料與建立可輕鬆新增至報表之視覺效果的作業更加多元。You can use insights when your report is in reading or editing mode, making it versatile for both analyzing data, and for creating visuals you can easily add to your reports.

考量與限制Considerations and limitations

因為深入解析是根據前一個資料點的變更來進行解析,所以選取視覺效果中的第一個資料點時,就無法使用此功能。Since insights are based on the change from the previous data point, they aren't available when you select the first data point in a visual.

下列清單是目前「深入解析」不支援的案例集合:The following list is the collection of currently unsupported scenarios for insights:

  • TopN 篩選TopN filters
  • 包含/排除篩選Include/exclude filters
  • 量值篩選Measure filters
  • 非加總量值和彙總Non-additive measures and aggregates
  • 顯示值為Show value as
  • 篩選量值 (這是我們用於深入解析散佈圖的新功能)Filtered measures (it’s the new thing we use for scatter chart in insights)
  • X 軸上的類別資料行 (除非它定義純量的依資料行排序作業)。Categorical columns on X-axis unless it defines a sort by column that is scalar. 如果使用階層,則在使用中階層內的每個資料行皆必須符合此條件If using a hierarchy, then every column in the active hierarchy has to match this condition
  • 非數字量值Non-numeric measures

此外,深入解析目前不支援下列模型類型和資料來源:In addition, the following model types and data sources are currently not supported for insights:

  • DirectQueryDirectQuery
  • Live connectLive connect
  • 內部部署的 Reporting ServicesOn-premises Reporting Services
  • 內嵌Embedding

後續步驟Next steps

如需 Power BI Desktop 的詳細資訊,以及如何開始使用,請參閱下列文章。For more information about Power BI Desktop, and how to get started, check out the following articles.