使用 Power BI Desktop 中的 [分析] 窗格Using the Analytics pane in Power BI Desktop

有了 Power BI Desktop 的 [分析] 窗格,您就可以將動態「參考線」新增至視覺效果,為重要的趨勢或深入解析提供焦點。With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights. [分析] 窗格位於 Power BI Desktop 的 [視覺效果] 區域中。The Analytics pane is found in the Visualizations area of Power BI Desktop.


[分析] 窗格只會在您選取了 Power BI Desktop 畫布上的視覺效果時顯示。The Analytics pane only appears when you select a visual on the Power BI Desktop canvas.

在分析窗格內進行搜尋Search within the Analytics pane

從 2018 年 2 月發行的 Power BI Desktop (2.55.5010.201 版或更新版本) 開始,您可以在 [分析] 窗格內進行搜尋,此窗格是 [視覺效果] 窗格的一個子區段。Beginning with the February 2018 release of Power BI Desktop (version 2.55.5010.201 or later), you can search within the Analytics pane, which is a sub-section of the Visualizations pane. 如下圖所示,選取 [分析] 窗格之後,就會出現搜尋方塊。As shown in the image below, search box appears when the Analytics pane is selected.

使用 [分析] 窗格Using the Analytics pane

透過 [分析] 窗格,您可以建立下列類型的動態參考線 (並非所有線都是用於所有視覺效果類型):With the Analytics pane, you can create the following types of dynamic reference lines (not all lines are available for all visual types):

  • X 軸常數線X-Axis constant line
  • Y 軸常數線Y-Axis constant line
  • 最小值線Min line
  • 最大值線Max line
  • 平均值線Average line
  • 最小值線Median line
  • 中間值線Percentile line

下列章節示範可以如何在視覺效果中使用 [分析] 窗格及動態參考線。The following sections show how you can use the Analytics pane and dynamic reference lines in your visualizations.

若要檢視視覺效果可用的動態參考線,請遵循下列步驟:To view the available dynamic reference lines for a visual, follow these steps:

  1. 選取或建立視覺效果,然後從 [視覺效果] 區段選取分析圖示。Select or create a visual, then select the Analytics icon from the Visualizations section.

  2. 針對您要建立的線類型選取向下箭號,以展開其選項。Select the down arrow for the type of line you want to create to expand its options. 在這個案例中,我們選取 [平均值線]。In this case, we'll select Average Line.

  3. 若要建立新的線,請選取 [+ 新增]。To create a new line, select + Add. 您接著可以為線指定名稱,方法是按兩下文字方塊,然後鍵入名稱。You can then specify a name for the line by double-clicking the text box, then typing in your name.

    您可以對線使用各種選項,例如選取其「色彩」、「透明度」、「樣式」及「位置」(相對於視覺效果的資料項目),以及是否要包含標籤。You have all sorts of options for your line, such as selecting its color, transparency, style and position (relative to the visual's data elements), and whether to include the label. 重要的是,您可以選取線要以視覺效果中的哪個 [量值] 為依據,方法是選取 [量值] 下拉式清單,其中已自動填入視覺效果中的資料項目。And importantly, you can select which Measure in the visual you want your line to be based upon by selecting the Measure drop down, which is automatically populated with data elements from the visual. 在這個案例中,我們選取 [天氣] 作為量值,加上 [平均天氣] 的標籤,然後自訂其他幾個選項,如下所示。In this case, we'll select Weather as the measure, label it Average Weather, and customize a few of the other options as shown below.

  4. 如果您希望資料標籤出現,請將 [資料標籤] 滑桿移為開啟。If you want to have a data label appear, move the Data label slider on. 當您這樣做時,即取得資料標籤的其他所有選項,如下圖所示。When you do so, you get a whole host of additional options for your data label, as shown in the following image.

  5. 請注意顯示在 [分析] 窗格中,[平均值線] 項目旁的數字。Notice the number that appears next to the Average line item in the Analytics pane. 這告訴您視覺效果上目前有多少條動態線及其類型。That tells you how many dyanmic lines you currently have on your visual, and of which type. 如果我們針對「生活花費」新增 [最大值線],您就會看到 [分析] 窗格顯示我們也對這個視覺效果套用了 [最大值線] 動態參考線。If we add a Max line for Cost of Living, you can see that the Analytics pane shows that we now also have a Max line dynamic reference line applied to this visual.

如果您選取的視覺效果無法套用動態參考線 (在這個案例中為 [地圖] 視覺效果),您就會在選取 [分析] 窗格時看到下列內容。If the visual you've selected can't have dynamic reference lines applied to it (in this case, a Map visual), you'll see the following when you select the Analytics pane.

透過 [分析] 窗格,您可以藉由建立動態參考線,醒目提示您感興趣的各種深入解析。There are all sorts of interesting insights you can highlight by creating dynamic reference lines with the Analytics pane.

我們正在規劃更多功能,包括讓視覺效果有更多動態參考線可以套用,因此請時常回來查看新功能。We're planning more features and capabilities, including expanding which visuals can have dynamic reference lines applied to them, so check back often for what's new.

套用預測Apply Forecasting

使用預測功能的方法為選取視覺效果,然後展開 [分析] 窗格的 [預測] 區段。You can use the Forecast feature by selecting a visual, then expanding the Forecast section of the Analytics pane. 您可以指定多個輸入以修改預測,例如「預測長度」、「信賴區間」等。You can specify many inputs to modify the forecast, such as the Forecast length, the Confidence interval, and others. 下圖顯示已套用預測的基本線條視覺效果,但您可以發揮想像力 (並隨意嘗試「預測」功能) 以了解可以如何將其套用至模型。The following image shows a basic line visual with forecasting applied, but you can use your imagination (and play around with the forecasting feature) to see how it can apply to your models.


使用動態參考線的能力取決於使用的視覺效果類型。The ability to use dynamic reference lines is based on the type of visual being used. 下表顯示目前有哪些視覺效果可以使用哪種動態線:The following list shows which dynamic lines are currently available for which visuals:

下列視覺效果可以完整使用動態線:Full use of dynamic lines are available on the following visuals:

  • 區域圖Area chart
  • 折線圖Line chart
  • 散佈圖Scatter chart
  • 群組直條圖Clustered Column chart
  • 群組橫條圖Clustered Bar chart

下列視覺效果只可從 [分析] 窗格使用「常數線」:The following visuals can use only a constant line from the Analytics pane:

  • 堆疊區域圖Stacked Area
  • 堆疊橫條圖Stacked Bar
  • 堆疊直條圖Stacked Column
  • 100% 堆疊橫條圖100% Stacked Bar
  • 100% 堆疊直條圖100% Stacked Column

下列視覺效果目前只有「趨勢線」選項:For the following visuals, a trend line is currently the only option:

  • 非堆疊折線圖Non-stacked Line
  • 群組直條圖Clustered Column chart

最後,非笛卡兒視覺效果目前無法從 [分析] 窗格套用動態線,例如:Lastly, non-Cartesian visuals cannot currently apply dynamic lines from the Analytics pane, such as:

  • 矩陣圖Matrix
  • 圓形圖Pie chart
  • 環圈圖Donut
  • 資料表Table

後續步驟Next steps

您可以使用 Power BI Desktop 執行各種作業。There are all sorts of things you can do with Power BI Desktop. 如需有關其功能的詳細資訊,請參閱下列資源:For more information on its capabilities, check out the following resources: