在 Power BI 問與答中詢問問題的秘訣Tips for asking questions in Power BI Q&A

問與答可辨識的字組與專有名詞Words and terminology that Q&A recognizes

此關鍵字清單並非完整清單。This list of keywords is not exhaustive. 想知道 Power BI 能否辨識關鍵字的最佳辦法,就是在問題方塊中輸入關鍵字。The best way to see if Power BI recognizes a keyword, is to try it out by typing it in the question box. 如果字詞顯示為灰色,表示 Power BI 無法辨識,或無法在目前內容中辨識。If the word or term is greyed out, then Power BI does not recognize it, or doesn’t recognize it in the current context.

下列清單使用現在式,但所有時態在大部分情況下皆可辨識。The list below uses present tense, but all tenses are recognized in most cases. 例如,“is” 包括 are、was、were、will be、have、has、had、will have、has got、do、does、did。For example, “is” includes are, was, were, will be, have, has, had, will have, has got, do, does, did. 而 “sort” 包括 sorted 和 sorting。And “sort” includes sorted and sorting. 此外,PowerBI 可辨識並包含單字的單複數形態。Also, PowerBI recognizes and includes singular and plural versions of a word. 例如,Power BI 可辨識 “year” 和 “years”。For example, Power BI recognizes “year” and “years”.

您若為資料集的擁有者,可新增語法與同義字,提升您客戶問與答結果的品質。If you are the owner of a dataset, add phrasings and synonyms to improve the Q&A results for your customers.

彙總:total、sum、amount、number、quantity、count、average、most、least、fewest、largest、smallest、highest、biggest、maximum、max、greatest、lowest、littlest、minimum、minAggregates: total, sum, amount, number, quantity, count, average, most, least, fewest, largest, smallest, highest, biggest, maximum, max, greatest, lowest, littlest, minimum, min

冠詞:a、an、theArticles: a, an, the

空白和布林值:blank、empty、null、前綴 “non” 或 “non-“、empty string、empty text、true、t、false、fBlank and Boolean: blank, empty, null, prefixed with “non” or “non-“, empty string, empty text, true, t, false, f

比較:vs、versus、compared to、compared withComparisons: vs, versus, compared to, compared with

連接詞:and、or、each of、with、versus、&、and、but、nor、along with、in addition toConjunctions: and, or, each of, with, versus, &, and, but, nor, along with, in addition to

縮寫︰問與答可辨識幾乎所有的縮寫,請試試看。例如:didn’t、haven’t、he’d、he’s、isn’t、it’s、she’ll、they’d、weren’t、where’ll、who’s、won’t、wouldn’t。Contractions: Q&A recognizes almost all contractions, try it out. Here are a few examples: didn’t, haven’t, he’d, he’s, isn’t, it’s, she’ll, they’d, weren’t, where’ll, who’s, won’t, wouldn’t.

日期:Power BI 可辨識大部分的日期字詞 (day、week、month、year、quarter、decade 等等) 和許多不同的日期格式 (請見下文)。Dates: Power BI recognizes most date terms (day, week, month, year, quarter, decade, etc…) and dates written in many different formats (see below). Power BI 也能辨識下列關鍵字:MonthName、Days 1-31、decade。Power BI also recognizes the following keywords: MonthName, Days 1-31, decade.

範例:January 3rd of 1995、January 3rd 1995、jan 03 1995、3 Jan 1995、the 3rd of January、January 1995、1995 January、1995-01、01/1995、月份名稱。Examples: January 3rd of 1995, January 3rd 1995, jan 03 1995, 3 Jan 1995, the 3rd of January, January 1995, 1995 January, 1995-01, 01/1995, names of months.

相對日期:today、right now、current time、yesterday、tomorrow、the current、next、the coming、last、previous、ago、before now、sooner than、after、later than、from、at、on、from now、after now、in the future、past、last、previous、within、in、over、N days ago、N days from now、next、once、twice。Relative dates: today, right now, current time, yesterday, tomorrow, the current, next, the coming, last, previous, ago, before now, sooner than, after, later than, from, at, on, from now, after now, in the future, past, last, previous, within, in, over, N days ago, N days from now, next, once, twice.

範例︰count of orders in the past 6 days。Example: count of orders in the past 6 days.

相等 (範圍):in、equal to、=、after、is more than、in、between、beforeEquality (Range): in, equal to, =, after, is more than, in, between, before

範例︰Order year is before 2012? (2012 以前的訂單年份?)Examples: Order year is before 2012? Price equals between 10 and 20? (大於等於 10、小於等於 20 的價格?)Price equals between 10 and 20? Is the age of John greater than 40? (John 超過 40 歲了嗎?)Is the age of John greater than 40? Total sales in 200-300? (介於 200-300 之間的銷售總額?)Total sales in 200-300?

相等 (值):is、equal、equal to、in、of、for、within、is in、is onEquality (Value): is, equal, equal to, in, of, for, within, is in, is on

範例:Which products are green? (哪些產品是綠色的?)Examples: Which products are green? Order date equals 2012. (訂單日期為 2012 年。)Order date equals 2012. Is the age of John 40? (John 40 歲嗎?)Is the age of John 40? Total sales that is not equal to 200? (不等於 200 的銷售總額?)Total sales that is not equal to 200? Order date of 1/1/2016. (訂單日期是 2016 年 1 月 1 日。)Order date of 1/1/2016. 10 in price? (價格為 10?)10 in price? Green for color? (顏色是綠色嗎?)Green for color? 10 in price? (價格為 10?)10 in price?

名稱:如果資料集中的資料行包含片語「名稱」(例如 EmployeeName),則問與答能了解該資料行中的值為名稱,而且您可以詢問像是「哪些員工名字是 Robert」。Names: If a column in the dataset contains the phrase "name" (e.g., EmployeeName), Q&A understands the values in that column are names and you can ask questions like "which employees are named robert."

代名詞:he、him、himself、his、she、herself、her、hers、it、itself、its、they、their、them、themselves、theirs、this、these、that、thosePronouns: he, him, himself, his, she, herself, her, hers, it, itself, its, they, their, them, themselves, theirs, this, these, that, those

查詢命令:sorted、sort by、direction、group、group by、by、show、list、display、give me、name、just、only、arrange、rank、compare、to、with、against、alphabetically、ascending、descending、orderQuery commands: sorted, sort by, direction, group, group by, by, show, list, display, give me, name, just, only, arrange, rank, compare, to, with, against, alphabetically, ascending, descending, order

範圍:greater、more、larger、above、over、>、less、smaller、fewer、below、under、<、at least、no less than、>=、at most、no more than、<=、in、between、in the range of、from、later、earlier、sooner、after、on、at、later than、after、since、starting with、starting from、ending withRange: greater, more, larger, above, over, >, less, smaller, fewer, below, under, <, at least, no less than, >=, at most, no more than, <=, in, between, in the range of, from, later, earlier, sooner, after, on, at, later than, after, since, starting with, starting from, ending with

時間:am、pm、o'clock、noon、midnight、hour、minute、second、hh:mm:ssTimes: am, pm, o'clock, noon, midnight, hour, minute, second, hh:mm:ss

範例:10 pm、10:35 pm、10:35:15 pm、10 oclock、noon、midnight、hour、minute、second。Examples: 10 pm, 10:35 pm, 10:35:15 pm, 10 oclock, noon, midnight, hour, minute, second.

前 N 個 (順序、排名):top、bottom、highest、lowest、first、last、next、earliest、newest、oldest、latest、most recent、nextTop N (order, ranking): top, bottom, highest, lowest, first, last, next, earliest, newest, oldest, latest, most recent, next

視覺效果類型:Power BI 所有的原生視覺效果類型。Visual types: all visual types native to Power BI. 如果是 [視覺效果] 窗格中的選項,就可以包含在問題中。If it's an option in the Visualizations pane, then you can include it in your question. 但手動加入 [視覺效果] 窗格中的自訂視覺效果例外。The exception to this is custom visuals that you've manually added to the Visualization pane.

範例︰以橫條圖依月份和銷售總額顯示區域資料Example: show districts by month and sales total as bar chart

Wh (關係詞、限定詞):when、where、which、who、whom、how many、how much、how many times、how often、how frequently、amount、number、quantity、how long、whatWh (relationship, qualified): when, where, which, who, whom, how many, how much, how many times, how often, how frequently, amount, number, quantity, how long, what

問與答可協助您將問題分段Q&A helps you phrase the question

問與答會盡可能地確保答案能精準反映所提出的問題。Q&A does its best to ensure that the answer accurately reflects the question being asked. 它以數種方式達成此目標。It does this in several ways. 但所有方法,您都可以完整、部份或完全不接受該動作。For all of these, you can accept the action in full, in part, or not at all. 當您輸入問題時,問與答會:As you type your question, Q&A:

  • 自動完成文組與問題。auto-completes words and questions. 它使用各種不同的策略,包括自動完成可辨識的字組、基礎活頁簿的熱門問題,以及先前已使用且傳回有效回應的問題。It uses various strategies, including auto-completing recognizable words, popular questions for the underlying workbooks, and previously-used questions that returned valid responses. 如果可使用一個以上自動完成選項,則選項會出現在下拉式清單中。If more than one auto-complete option is available, they are presented in a dropdown list.
  • 更正拼字。corrects spelling.
  • 以視覺效果形式提供回答的預覽結果。provides a preview of the answer in the form of a visualization. 視覺效果會在您輸入及編輯問題時更新 (不用等您按下 Enter 鍵)。The visualization updates as you type and edit the question (it doesn't wait for you to press Enter).
  • 將游標移回 [問題] 方塊時,從基礎資料集自動建議取代的字詞。auto-suggests replacement terms from the underlying dataset(s) when you move the cursor back in the question box.
  • 依據基礎資料集中的資料,再次陳述問題。restates the question based on the data in the underlying dataset(s). 這有助於確保問與答能了解您的問題,因為問與答會將您使用的字組,以基礎資料集的同義字取代。This helps ensure Q&A understood your question as Q&A replaces the words you used with synonyms from the underlying dataset(s).
  • 不了解的字組會變暗。dims words it does not understand.

合併來自多個資料集的結果Combine results from more than one dataset

Power BI 最強大的功能之一是能夠合併來自不同資料集的資料。One of Power BI's most powerful features is the ability to combine data from different datasets. 因此不要將您的問題侷限在單一資料集,您可以詢問從多個資料集擷取資料的問題。So don't limit your questions to a single dataset -- ask questions that retrieve data from more than one dataset. 例如,如果我的儀表板包含來自零售分析範例的磚及州人口資料集,我可以要求依州人口以橫條圖遞減顯示商店計數.For example, if my dashboard has tiles from the Retail Analysis Sample and a state population dataset, I can ask show count of stores by state population as bar chart descending.

不立即停止Don't stop now

問與答顯示您的結果之後,持續保存交談內容!After Q&A displays your results, keep the conversation going! 使用視覺效果的互動功能與問答集,發掘更多深入資訊。Use the interactive features of the visualization and of Q&A to uncover more insights.

後續步驟Next steps

回到 Power BI 中的問與答Back to Q&A in Power BI

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

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