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

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

• 顯示目標的達成進度。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

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

1. 選取 取得資料>檔案 並瀏覽至您儲存檔案的位置，在 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.
2. 選取 [財務範例] ，在瀏覽模式中加以開啟。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

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.

## 使用格式化選項來手動設定最小值、最大值與目標值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

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