在 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.

聚合:总计、求和、金额、数字、数量、计数、平均值、最多、最少、最大、最小、最高、最大值、最大(值)、最低、最小值、最小(值)Aggregates: 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

空白和布尔值:空白、空、null、以“非”为前缀、空字符串、空文本、true、t、false、fBlank and Boolean: blank, empty, null, prefixed with “non” or “non-“, empty string, empty text, true, t, false, f

比较词:vs、对比、比较Comparisons: vs, versus, compared to, compared with

连词:和、或、每个、与、比较、&、和、但是、也不、加之、除了Conjunctions: and, or, each of, with, versus, &, and, but, nor, along with, in addition to

缩约词:Q&A 可识别几乎所有的缩约词,请尝试一下。下面是一些示例: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 可识别大多数日期术语(日、周、月、年、季度、十年等)以及以多种不同格式编写的日期(见下文)。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 还可识别下列关键字:月份名称、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.

相对日期:今天、立刻、当前时间、昨天、明天、当前、下一个、即将到来的、上个、之前、以前、早于、之后、晚于、从、在(某个时间)、在(某天)、今后、以后、未来、过去、(时间)内、(几天)后、超过、N 天前、N 天后、下一个、一次、两次。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.

示例:过去 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 is not equal to 200? 订购日期为 2016/1/1。Order date of 1/1/2016. 价格是 10?10 in price? 颜色是绿色?Green for color? 价格是 10?10 in price?

名称:如果数据集中的列包含词组“姓名”(如“员工姓名”),则“问答”会将该列中的值理解为姓名,你可以像这样提问,例如“哪些员工的名字叫 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."

代词:他、他自己、他的、她、她自己、她的、它、它自己、它的、他们、他们的、他们自己、这、这些、那、那些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

时间:am(上午)、pm(下午)、…点钟、中午、午夜、小时、分钟、秒、时:分:秒Times: am, pm, o'clock, noon, midnight, hour, minute, second, hh:mm:ss

示例:10 pm(下午 10 点)、10:35 pm(下午 10:35)、10:35:15 pm(下午 10:35:15)、10 点钟、中午、午夜、小时、分钟、秒。Examples: 10 pm, 10:35 pm, 10:35:15 pm, 10 oclock, noon, midnight, hour, minute, second.

前 N 个(排序、排名):前...名、后...名、最高、最低、第一、最后、下个、最早、最新、最旧、最新的、最近的、下一个Top 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 (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