在 Power BI 问答中提问的提示Tips for asking questions in Power BI Q&A

“问答”识别的单词和术语Words and terminology that Q&A recognizes

此页上的关键字列表并不详尽。The list of keywords on this page isn't 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 doesn't recognize it.

下面的列表使用现在时,但在大多数情况下能识别所有时态。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. 此外,Power BI 还识别并添加单数和复数形式的单词。Power BI also recognizes and includes singular and plural versions of a word.

类别Category 关键字Keywords Column3Column3
聚合Aggregates 总计、求和、金额、数字、数量、计数、平均值、最多、最少、最大、最小、最高、最大值、最大(值)、最低、最小值、最小(值)total, sum, amount, number, quantity, count, average, most, least, fewest, largest, smallest, highest, biggest, maximum, max, greatest, lowest, littlest, minimum, min
冠词Articles a、an、thea, an, the
空白和布尔值Blank and Boolean 空白、空、null、以“非”为前缀、空字符串、空文本、true、t、false、fblank, empty, null, prefixed with “non” or “non-“, empty string, empty text, true, t, false, f
比较词Comparisons vs、对比、比较vs, versus, compared to, compared with
连词Conjunctions 和、或、每个、与、比较、&、和、但是、也不、加之、除了and, or, each of, with, versus, &, and, but, nor, along with, in addition to
缩约词Contractions Q&A 可识别几乎所有的缩约词,请尝试一下。比如下面这几个例子:didn’t、haven’t、he’d、he’s、isn’t、it’s、she’ll、they’d、weren’t、who’s、won’t、wouldn’tQ&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, who’s, won’t, wouldn’t
日期Dates Power BI 可识别大多数日期术语(日、周、月、年、季度、十年等)以及以多种不同格式编写的日期(见下文)。Power BI recognizes most date terms (day, week, month, year, quarter, decade, ...) and dates written in many different formats (see below). Power BI 还可识别下列关键字:月份名称、1 - 31 日、十年。Power BI also recognizes the following keywords: MonthName, Days 1-31, decade. 示例:January 3rd of 1995(1995 年 1 月 3 日)、January 3rd 1995、jan 03 1995、3 Jan 1995、the 3rd of January、January 1995(1995 年 1 月)、1995 January、1995-01、01/1995(1995/01)、月份名称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
相对日期Relative dates 今天、立刻、当前时间、昨天、明天、当前、下一个、即将到来的、上个、之前、以前、早于、之后、晚于、从、在(某个时间)、在(某天)、今后、以后、未来、过去、(时间)内、(几天)后、超过、N 天前、N 天后、下一个、一次、两次。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.
示例:过去 6 天的订单数。Example: count of orders in the past 6 days.
等式(范围)Equality (Range) 在…中、等于、=、晚于、超过、在…内、在…之间、以前in, equal to, =, after, is more than, in, between, before
示例:2012 年以前的订单年份?Examples: Order year is before 2012? 价格在 10 和 20 之间?Price equals between 10 and 20? John 的年龄大于 40 岁吗?Is the age of John greater than 40? 总销售额在 200 - 300?Total sales in 200-300?
等式(值)Equality (Value) 是、为、等于、在…中、…的…、在…内、在…中、在…上is, equal, equal to, in, of, for, within, is in, is on
示例:哪些产品是绿色的?Examples: Which products are green? 订单日期为 2012 年。Order date equals 2012. John 的年龄是 40 岁?Is the age of John 40? 总销售额不等于 200?Total sales that aren't equal to 200? 订购日期为 2016/1/1。Order date of 1/1/2016. 价格是 10?10 in price? 颜色是绿色?Green for color? 价格是 10?10 in price?
名称Names 如果数据集中的列包含词组“姓名”(如“员工姓名”),则“问答”会将该列中的值理解为姓名。If a column in the dataset contains the phrase "name" (for example, EmployeeName), Q&A understands the values in that column are names. 你可以像这样提问,例如“哪些员工的名字叫 robert”。You can ask questions like "which employees are named robert."
代词Pronouns 他、他自己、他的、她、她自己、她的、它、它自己、它的、他们、他们的、他们自己、这、这些、那、那些he, him, himself, his, she, herself, her, hers, it, itself, its, they, their, them, themselves, theirs, this, these, that, those
查询命令Query 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
范围Range 大于、多于、较大、以上、超过、>、少于、较小、较少、以下、低于、<、至少、不少于、>=、最多、不多于、<=、在…中、在…间、在…范围、从…中、更晚、更早、早于、晚于、在(某天)、在(某时间)、比…晚、晚于、从…起、以…开始、从…开始、以…结束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
时间Times am(上午)、pm(下午)、…点钟、中午、午夜、小时、分钟、秒、时:分:秒am, pm, o'clock, noon, midnight, hour, minute, second, hh:mm:ss
示例:10 pm、10:35 pm、10:35:15 pm、10 o clock、noon、midnight、hour、minute、second。Examples: 10 pm, 10:35 pm, 10:35:15 pm, 10 o clock, noon, midnight, hour, minute, second.
前 N 个Top N (排序、排名):前...名、后...名、最高、最低、第一、最后、下个、最早、最新、最旧、最新的、最近的、下一个(order, ranking): top, bottom, highest, lowest, first, last, next, earliest, newest, oldest, latest, most recent, next
视觉对象类型Visual types 来源于 Power BI 的所有视觉对象。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 rule is custom visuals that you've manually added to the Visualization pane.
示例:按照月份和销售总额以条形图显示地区Example: show districts by month and sales total as bar chart
疑问词(关系、限定)Wh (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 understand and answer the question being asked. 它将尝试从几个方面去理解。It tries to understand in several ways. 对于所有这些表述,可以全部、部分接受或根本不接受操作。For all of these phrasings, you can accept the action in full, in part, or not at all. 当你键入问题时,“问答”:As you type your question, Q&A:

  • 会自动完成单词和问题。autocompletes words and questions. 它使用各种策略,包括自动完成已识别的单词、已存储的问题和已返回有效回复的以前用过问题。It uses various strategies, including autocompleting recognized words, stored questions, and previously used questions that returned valid responses. 如果有多个自动完成选项可用,则会出现在下拉列表中。If more than one autocomplete option is available, they're presented in a dropdown list.
  • 更正拼写。corrects spelling.
  • 以视觉对象的形式提供答案预览。provides a preview of the answer in the form of a visual. 视觉对象会在你键入和编辑问题的同时更新(它不会等你按下 Enter 才更新)。The visual updates as you type and edit the question (it doesn't wait for you to press Enter).
  • 当你在问题框中将光标往回移动时,建议来自基础数据集的替换术语。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). “问答”采用来自基础数据集中的同义词替换你所用的单词。Q&A replaces the words you used with synonyms from the underlying dataset(s). 通过查看重述,你将了解“问答”是否理解了你的问题。By reading the restatement, you know whether Q&A understood your question or not.
  • 不能理解的模糊词。dims words it doesn't understand.

暂不停止Don't stop now

“问答”显示结果后,请保持继续谈话!After Q&A displays your results, keep the conversation going! 使用视觉对象和问答的交互功能发掘更多见解。Use the interactive features of the visual 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