| title | description | author | ms.author | ms.reviewer | ms.service | ms.subservice | ms.topic | ms.date | LocalizationGroup | no-loc | |
|---|---|---|---|---|---|---|---|---|---|---|---|
Write Copilot prompts to create narrative visuals in Power BI |
Read about samples of prompts that help Copilot produce useful narrative visuals in Power BI. |
maggiesMSFT |
maggies |
cnews |
powerbi |
pbi-reports-dashboards |
conceptual |
01/11/2024 |
Create reports |
|
[!INCLUDE applies-no-desktop-yes-service]
If you have edit permission for a report, Copilot can create a narrative visual for you on the report page. If you don't have edit permission, you still use Copilot to get insights about the report, by asking questions in the Copilot pane. See the article Summarize your report content in the Copilot pane for details.
[!INCLUDE copilot-notes]
Here are some examples of prompts that work well for creating narrative visuals with Copilot for Power BI. Use these prompts as examples.
Each sample prompt is paired with a narrative that Copilot generated based on the interpretation of that prompt. Your prompts help Copilot understand what you're looking for, but they may not produce a narrative that's exactly what you want.
Modify an existing narrative. You can use the custom prompt area to modify an existing narrative to adjust the tone, formatting, or tweak the summary to your needs. Following are some examples.
Also, see the Considerations and limitations section in the article "Create a narrative with Copilot for Power BI" for features that currently don't work.
First we start from scratch, using custom prompts to generate a narrative. Help the summary focus on one aspect of your data.
"Generate a summary focused on tourism in Hawaii."
:::image type="content" source="media/copilot-prompts/summary-about-hawaii.png" alt-text="Screenshot showing Generate a summary focused on tourism in Hawaii." lightbox="media/copilot-prompts/summary-about-hawaii.png":::
Here's the original narrative from the suggested prompt:
:::image type="content" source="media/copilot-prompts/suggested-prompt-1.png" alt-text="Screenshot showing original narrative from the suggested prompt." lightbox="media/copilot-prompts/suggested-prompt-1.png":::
First we modify the narrative with this custom prompt:
"Shorten this summary and bold the key information"
:::image type="content" source="media/copilot-prompts/shortened-summary.png" alt-text="Screenshot showing Shorten this summary and bold the key information." lightbox="media/copilot-prompts/shortened-summary.png":::
This time, we again modify the summary by using a different custom prompt:
"Make the first bullet point about length of stay."
:::image type="content" source="media/copilot-prompts/length-of-stay-summary.png" alt-text="Screenshot showing Make the first bullet point about length of stay." lightbox="media/copilot-prompts/length-of-stay-summary.png":::
This time, we again modify the summary by using a different custom prompt:
"Add the question "What are the factors that influence customer retention and return rate?"
:::image type="content" source="media/copilot-prompts/modified-question-prompt.png" alt-text="Screenshot showing factors that influence customer retention and return rate." lightbox="media/copilot-prompts/modified-question-prompt.png":::
Create a narrative answer investigating something specific in your report. For example, this prompt:
"Generate a summary explaining the relationship between revenue, location, and primary interest."
:::image type="content" source="media/copilot-prompts/explain-relationship.png" alt-text="Screenshot showing summary explaining the relationship between revenue, location, and primary interest." lightbox="media/copilot-prompts/explain-relationship.png":::
We always welcome your feedback about our products. Especially during public preview, your feedback helps us improve the product faster.