Query on Copilot for report creation

[han_rj]

Hi Team,

I am exploring copilot for Report creating and I want the below prompts to return visuals,but the below prompts are not working as expected .Please may I have help correct where I am going wrong in writtting these prompts.

create a column chart showing sales and GP Margin by products on the same chart.
--Output two separate bar charts one for sales and another for GP Margin

Top 5 products by Sales 

--Output returned is Sales of all products

KPI card showing Total Orders and Target Order

--Output Shows a text card with total orders

Using Contoso Dataset for this exercise

Output Expected

[v-veshwara-msft · Accepted solution]

Hi @han_rj ,

Thank you for reaching out in Microsoft Fabric Community,

Copilot for Power BI is currently in preview, and there are some limitations regarding the types of visuals it can generate. Certain complex visual types, such as clustered column charts, key influencers may not always be generated as expected. Instead, Copilot might create separate charts or apply different color variations within a single chart. If the generated visuals are not aligning with your expectations, this could be due to these current limitations.

For more details on Copilot’s capabilities and limitations, you can refer to the official Microsoft documentation:
Create a narrative with Copilot for Power BI - Power BI | Microsoft Learn
Overview of Copilot for Power BI - Power BI | Microsoft Learn

To improve Copilot’s ability to generate the right visuals, you may want to update your data model.
Update your data model to work well with Copilot for Power BI - Power BI | Microsoft Learn
Ensuring proper relationships between tables, and structuring the data at the right level of granularity can help Copilot interpret the data more effectively.

If Copilot still does not generate the expected clustered column chart, manual adjustments may be necessary. As Copilot is still evolving, future updates may improve support for additional visuals. If you continue to experience issues, feel free to share your observations, as feedback helps improve Copilot’s capabilities.

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best Regards,
Vinay.

[Akash_Varuna]

Hi @han_rj , You need to tailor your prompt more specifically in way in which that it understands what you want  Like in case of Top 5 products 
Create a bar chart that displays the top 5 products based on Sales, sorted in descending order like sorting it to avoid all products listing

[han_rj]

I received a response from copilot stating sorting is not  supported in the current set of functionality.You can manually sort the data