如何使用 Power BI 問與答How to use Power BI Q&A

使用自然語言詢問資料相關的問題Ask questions of your data using natural language

啟動儀表板。Start on a dashboard. [問與答] 方塊是您使用自然語言來輸入問題的地方。The Q&A question box is where you type your question using natural language. 問與答辨識您輸入的文字,然後找出哪裡 (哪個資料集) 可尋找解答。Q&A recognizes the words you type and figures out where (which dataset) to find the answer. 問與答也可以用自動完成、重新描述,和其他文字及視覺輔助工具,協助您建立問題。Q&A also helps you form your question with auto-completion, restatement, and other textual and visual aids.

您問題的答案會顯示為互動式的視覺效果,而且每當您修改問題時便會更新。The answer to your question is displayed as an interactive visualization and updates as you modify the question.

問與答易於互動,甚至充滿樂趣,而且,一個問題多半會帶來更多其他問題,原因在於視覺效果會顯示可探索的有趣路徑。Q&A is interactive and even fun, and, more often than not, one question will lead to many others as the visualizations reveal interesting paths to pursue. 觀看 Amanda 示範使用問與答來建立視覺效果、深入探討這些視覺效果,以及將其釘選至儀表板。Watch Amanda demonstrate using Q&A to create visuals, dig into those visuals, and pin them to dashboards.

使用自然語言詢問您資料的相關問題Use natural language to ask questions about your data

  1. 請將游標放在 [問題] 方塊中。Place your cursor in the question box. 即使您還沒開始輸入,問與答也會顯示包含建議的新畫面,以協助您提出問題。Even before you start typing, Q&A displays a new screen with suggestions to help you form your question.

    此清單包含:This list contains:
    a.a. 用以建立的問題 (此類磚已釘選到儀表板),以及the questions used to create tiles that are already pinned to the dashboard, and
    b.b. 基礎資料集中的資料表名稱。the name of tables in the underlying dataset(s).

    您一律可以選擇這些問題的其中一個做為起點,並繼續精簡問題,藉此尋找您要的特定解答。You can always choose one of these questions as a starting point and continue to refine the question to find the specific answer you are looking for. 或者,使用資料表名稱來幫助您撰寫新的問題。Or, use a table name to help you word a new question.

  2. 從下拉式清單中選取,或輸入您自己的問題。Select from the dropdown or begin typing your own question.

  3. 當您輸入了問題後,Power BI 問與答會挑選最佳的視覺效果來顯示您的答案;而當您修改這個問題時,視覺效果就會動態改變。As you type a question, Power BI Q&A picks the best visualization to display your answer; and the visualization changes dynamically as you modify the question. 問與答也可以透過自動完成、重新描述您的問題,以及利用其他文字和視覺輔助工具,協助您建立問題。Q&A also helps you formulate your question with auto-completion, by restating your question, and with other textual and visual aids.
  4. 當您輸入查詢時,Power BI 會在儀表板上有圖格之任何資料集尋找解答。When you type a query, Power BI looks for an answer in any dataset that has a tile on that dashboard. 如果所有的圖格都來自 datasetA ,則您的答案將來自 datasetAIf all the tiles are from datasetA, then your answer will come from datasetA. 如果有磚來自 datasetAdatasetB ,則問與答就會搜尋這 2 個資料集的最佳回應。If there are tiles from datasetA and datasetB, then Q&A will search for the best answer from those 2 datasets.


    所以要小心,如果只有一個磚來自 datasetA ,而您從儀表板中移除了,問與答將不再有權存取 datasetASo be careful, if you only have one tile from datasetA and you remove it from your dashboard, Q&A will no longer have access to datasetA.

  5. 如果您很滿意結果,請將視覺效果釘選到儀表板,方法是選取在右上角的釘選圖示。When you're happy with the result, pin the visualization to a dashboard by selecting the pin icon in the top right corner. 如果儀表板已與您共用或為應用程式的一部分,您就無法釘選。If the dashboard has been shared with you, or is part of an app, you won't be able to pin.

告訴問與答要使用的視覺效果。Tell Q&A which visualization to use.

在使用問與答的時候,您不只可以要求要說明資料,也可以告訴它要如何顯示。With Q&A, not only can you ask your data to speak for itself, you can tell it how you want it displayed. 只需在問題結尾加上「為」。Just add "as a " to the end of your question. 例如「依工廠顯示庫存量為地圖」和「顯示總庫存為卡片」。For example, "show inventory volume by plant as a map" and "show total inventory as a card". 請自己試試看吧。Try it for yourself.

問與答如何知道要怎麼回答問題?How does Q&A know how to answer questions?

問與答使用了哪些資料集?Which datasets does Q&A use?

問與答怎知道要如何回答特定資料的問題?How does Q&A know how to answer data-specific questions? 它依賴基礎資料集中的資料表、資料行與導出欄位的名稱。It relies on the names of the tables, columns, and calculated fields in the underlying dataset. 因此您 (或資料集擁有者) 為其命名的方式相當重要!So what you (or the dataset owner) call things is important!

例如,假設您有一個名為「銷售」的 Excel 資料表,其資料行標題為「產品」、「月」、「單位銷售」、「銷售毛額」和「利潤」。For example, suppose you had an Excel table named “Sales”, with columns titled “Product”, “Month”, “Units Sold”, “Gross Sales”, and “Profit”. 您可以詢問有關任何這些實體的問題。You could ask questions about any of those entities. 您可以詢問「顯示銷售」、「各月份的總收益」、「依單位銷售排序產品」等等問題。You could ask "show sales, "total profit by month", "sort products by units sold", and more.

問與答可以回答的問題,取決於您的資料集是如何組織的。Q&A can answer questions that are based on how your dataset is organized. 在 Salesforce 中的資料也能使用問與答嗎?How would this work for data in Salesforce? 當您連線到 salesforce.com 帳戶時,Power BI 會自動產生儀表板。When you connect to your salesforce.com account, Power BI generates a dashboard automatically. 開始使用問與答詢問問題之前,請先查看在儀表板視覺效果中顯示的資料,以及問與答下拉式清單中顯示的資料。Before you start asking questions with Q&A, take a look at the data displayed in the dashboard visualizations and also at the data displayed in the Q&A dropdown.

  • 如果視覺效果軸的標籤和值包含「銷售」、「客戶」、「月」與「商機」,您可以放心地詢問:哪位「客戶」的「商機」最大等問題,或顯示每月「銷售」的橫條圖。If the visualizations' axis labels and values include "sales", "account", "month", and "opportunities", then you can confidently ask questions such as: "Which account has the highest opportunity, or show sales by month as a bar chart."
  • 如果下拉式清單中包含「銷售人員」、「州」及「年」,您可以放心地詢問:「2013 年時,佛羅里達州 哪位銷售人員 的銷售量 最低」等問題。If the dropdown includes "salesperson", "state", and "year", then you can confidently ask questions such as: "which salesperson had the lowest sales in Florida in 2013."

如果您在 Google Analytics 網站有效能資料,您或許可以詢問問與答有關花在網頁的時間、特定網頁瀏覽次數和使用者參與率。If you have website performance data in Google Analytics, you could ask Q&A about time spent on a web page, number of unique page visits, and user engagement rates. 或者,如果您要查詢人口統計資料,您可能會想詢問各地區年齡和家庭收入的相關問題。Or, if you’re querying demographic data, you might ask questions about age and household income by location.

問與答會使用哪一種視覺效果?Which visualization does Q&A use?

問與答會根據要顯示的資料挑選最佳視覺效果。Q&A picks the best visualization based on the data being displayed. 有時在基礎資料集中資料的定義是特定類型或類別目錄,這就有助於問與答知道要如何加以顯示。Sometimes data in the underlying dataset(s) is defined as a certain type or category and this helps Q&A know how to display it. 例如,如果將資料定義為日期類型,則較有可能顯示為折線圖。For example, if data is defined as a date type, it is more likely to be displayed as a line chart. 分類為城市的資料比較有可能顯示為地圖。Data that is categorized as a city is more likely to be displayed as a map.

您也可以告知問與答要使用哪一種視覺效果,方法是將視覺效果類型加入您的問題中。You can also tell Q&A which visualization to use by adding it to your question. 但是請記住,以您要求的視覺效果類型讓問與答顯示資料,並不一定可行。But keep in mind that it may not always be possible for Q&A to display the data in the visualization type you requested.

如需問與答可辨識的關鍵字相關資訊,請參閱詢問問題的秘訣For information about keywords that Q&A recognizes, see Tips for asking questions.

後續步驟Next steps

回到 Power BI 中的問與答Back to Q&A in Power BI
教學課程:在零售分析範例使用問與答Tutorial: Use Q&A with the Retail Sales sample
在問與答中詢問問題的秘訣Tips for asking questions in Q&A
準備適用於問與答的活頁簿Prepare a workbook for Q&A
從問與答將磚釘選至儀表板Pin a tile to the dashboard from Q&A