Power BI 中的星形量測計圖表 (教學課程)Radial gauge charts in Power BI (Tutorial)

星形量測計圖表具有圓弧線段,並且會顯示針對某一目標/KPI 測量進度的單一值。A radial gauge chart has a circular arc and displays a single value that measures progress toward a goal/KPI. 目標或目標值是由線條 (指針) 表示。The goal, or target value, is represented by the line (needle). 達到該目標的進度是由陰影表示。Progress toward that goal is represented by the shading. 代表該進度的值會以粗體顯示在弧線內。所有可能的值會從最小 (最左邊的值) 到最大 (最右邊的值) 平均分散在弧線上。And the value that represents that progress is shown in bold inside the arc. All possible values are spread evenly along the arc, from the minimum (left-most value) to the maximum (right-most value).

下列範例中,我們是汽車零售商,正在追蹤銷售團隊每個月的平均銷售額。In the example below, we are a car retailer, tracking our Sales team's average sales per month. 我們的目標是 140,以黑色指針代表。Our goal is 140 and represented by the black needle. 最小的可能平均銷售量是 0,而我們將最大值設為 200。The minimum possible average sales is 0 and we've set the maximum as 200. 藍色陰影顯示我們這個月的銷售量目前平均約為 120。The blue shading shows that we're currently averaging approximately 120 sales this month. 幸好我們還有一週的時間來達成目標。Luckily, we still have another week to reach our goal.

使用星形量測計的時機When to use a radial gauge

星形量測計極適合用來:Radial gauges are a great choice to:

  • 顯示目標的達成進度。show progress toward a goal.
  • 代表 KPI 等百分位數量值。represent a percentile measure, like a KPI.
  • 顯示單一量值的健全狀況。show the health of a single measure.
  • 顯示可快速掃描和了解的資訊。display information that can be quickly scanned and understood.

建立基本的星形量測計Create a basic radial gauge

這些指示使用財務範例。These instructions use the Financial Sample. 如果要跟著做,請下載範例到您的電腦、登入 Power BI 並選取 取得資料>檔案>本機檔案] > [開啟To follow along, download the sample to your computer, sign in to Power BI and select Get Data > Files > Local File > Open.

或觀看 Will 說明如何建立單一計量的視覺效果︰量測計、卡片及 KPI。Or watch Will show you how to create single metric visuals: gauges, cards, and KPIs.

步驟 1:開啟財務範例 Excel 檔案。Step 1: Open the Financial Sample Excel file.

  1. 下載範例財務 Excel 檔案Download the sample Financial Excel file.
  2. 選取 取得資料>檔案 並瀏覽至您儲存檔案的位置,在 Power BI 中開啟檔案。Open the file in Power BI by selecting Get Data > Files and browsing to the location where you saved the file. 選取 [匯入]。Select Import. 財務範例隨即加入工作區成為資料集。The Financial Sample is added to your workspace as a dataset.
  3. 選取 [財務範例] ,在瀏覽模式中加以開啟。Select Financial Sample to open it in Explore mode.

步驟 2:建立追蹤總銷售額的量測計Step 2: Create a gauge to track Gross Sales

  1. 在 [欄位] 窗格中,選取 [總銷售額] 。In the Fields pane, select Gross Sales.

  2. 將彙總變更為 [平均] 。Change the aggregation to Average.

  3. 選取量測計圖示 將直條圖轉換成量測計。Select the gauge icon to convert the Column Chart to a gauge.

    Power BI 預設會建立量測計圖表,其中假設目前值 (在此案例中為平均總銷售額) 為量測計的中間點。By default, Power BI creates a Gauge chart where the current value (in this case, Average of Gross Sales) is assumed to be at the halfway point on the gauge. 由於平均總銷售額是美金 $182.76K 元,開始值 (最小值) 設定為 0 且結束值 (最大值) 設定為目前值的兩倍。Since the Average Gross Sales is $182.76K, the start value (Minimum) is set to 0 and the end value (Maximum) is set to double the current value.

步驟 3:設定目標值Step 3: Set a target value

  1. 將 [COGS] 拖曳至 [目標值] 井。Drag COGS to the Target value well.
  2. 將彙總變更為 [平均] 。Change the aggregation to Average. Power BI 會加入指針來代表我們的目標值:$145.48KPower BI adds a needle to represent our target value of $145.48K. 請注意到我們已經超過目標。Notice that we've exceeded our target.

    注意

    您也可以手動輸入目標值。You can also manually enter a target value. 請參閱下方的<使用格式化選項來手動設定最小值、最大值與目標值>See "Use formatting options to manually set Minimum, Maximum, and Target values" below.

步驟 4:設定最大值Step 4: Set a maximum value

在步驟 2 中,Power BI 會使用 [值] 欄位來自動設定最小值 (開始) 與最大值 (結束)。In Step 2, Power BI used the Value field to automatically set minimum (start) and maximum (end). 但如果您想自行設定最大值該怎麼做?But what if you want to set your own maximum value? 假設您不想使用目前值的兩倍做為最大的可能值,而要將它設定為資料集裡最高的總銷售額數字?Let's say that instead of using double the current value as the maximum possible value, you want to set it to the highest Gross Sales number in your dataset?

  1. 將 [總銷售額] 從 [欄位] 清單拖曳到 [最大值] 。Drag Gross Sales from the Fields list to the Maximum Value well.
  2. 將彙總變更為 [最大值] 。Change the aggregation to Maximum.

    接著會以新的結束值 (總銷售額 121 萬) 重新繪製量測計。The gauge is redrawn with a new end value, 1.21 million in gross sales.

步驟 5:儲存報表。Step 5: Save your report

  1. 儲存報表Save the report.
  2. 將量測計圖表加入為儀表板的磚Add the gauge chart as a dashboard tile.

使用格式化選項來手動設定最小值、最大值與目標值Use formatting options to manually set Minimum, Maximum, and Target values

  1. 將 [銷售額的最大值] 從 [最大值] 部分移除。Remove Max of Gross Sales from the Maximum value well.
  2. 選取油漆滾筒圖示,開啟格式化窗格。Open the formatting pane by selecting the paint roller icon.

  3. 展開 [量測計軸] 並輸入 [最小] 與 [最大] 的值。Expand the Gauge axis and enter values for Min and Max.

  4. 移除 COGS旁的核取記號,以移除目前的目標值。Remove the current target value by removing the checkmark next to COGS.

  5. 當 [量測計軸] 下出現 [目標] 欄位時,請輸入值。When the Target field appears under Gauge axis, enter a value.

  6. 可選擇繼續格式化量測計圖。Optionally, continue formatting your gauge chart.

後續步驟Next steps

Power BI 中的視覺效果類型Visualization types in Power BI

將視覺效果新增至報表Add a visualization to a report

將視覺效果釘選至儀表板Pin a visualization to a dashboard

Power BI - 基本概念 Power BI - Basic Concepts

有其他問題嗎?More questions? 試試 Power BI 社群Try the Power BI Community