Use the full capabilities of Power BI to create special report pages, called answer cards designed specifically to answer Cortana questions.

Before you begin

Before you can begin using answer cards for Cortana, enable Cortana for Power BI.

Create an answer card designed specifically for Cortana

An answer card in a report is sized specifically for Cortana so that Cortana can display it in-screen as an answer to a question. To create an answer card for Cortana:

  1. We recommend starting with a blank report page.

  2. In the Visualizations pane, select the paint roller icon and choose Page Size > Type > Cortana.

  3. Create a visual or a set of visuals that you want to appear in Cortana in response to a particular question (or set of questions).

  4. Ensure that all visuals fit within the page borders. Optionally, modify display settings, data labels, colors, and backgrounds.

  5. Name the page and add alternate names. Cortana uses these names when it searches for results. In the Visualizations pane, select the paintbrush icon and choose Page Information. Enable Q&A for this visual by moving the slider to On.

    Tip:

    To improve results, avoid using words that are also column names.

  6. Optionally, if your report has page level filters, you can set Require single selection. Cortana will only display this report as an answer if one, and only one, of the filter items is specified in the question.

    For example, if you ask Cortana:

    • "show sales by store name," this Answer Page will not appear because you did not include any of the items in the required page level filter.
    • "show sales for Cary Lindseys and Charlotte Lindseys," this Answer Page will not appear because you specified more than one item from the required page level filter.
    • "show sales for Charlotte Lindseys," this Answer Page will display.

Now, asking a question including the name of a Cortana-sized page will return results from Cortana.

Note:

You don't have to set Require single selection to ask Cortana to display a report with page level filters. For example “show sales for Charlotte Lindseys” will get answer page regardless Require Single Selection status.

Important:

Before your answer card can be accessed by Cortana, you will need to Enable the dataset for Cortana.

How does Cortana order the results?

Results with high scoring answers (such as a complete match of a specified page name) will appear first as a best match in Cortana. Multiple best matches can appear if there are multiple answer cards in Power BI. Medium or lower scoring answers, such as answers not based on the name of an answer card or a question with words not understood by Power BI, are listed as links below best matches in Cortana.

Note:

When a new dataset or custom answer card is added to Power BI and enabled for Cortana it can take up to 30 minutes for results to begin appearing in Cortana. Logging in and out of Windows 10, or otherwise restarting the Cortana process in Windows 10, will allow new content to appear immediately.

See also

Using Cortana with Power BI

Still can't get Cortana to work with Power BI? Try the Cortana troubleshooter.

More questions? Try the Power BI Community