create charts with power query

[rzhuo6763]

Hi I am new to Power BI. I am working on a project to autmatically generate reports and I am wondering if powerbi is cabable of doing it.

The flow will be 

• keep the columns in the table with Logical.Type (Done with PowerQuery)
• generate pie chart from those columns

I am wondering if Power BI can do the second step also with Power Query. If not, does Power BI support creating charts without manual work from existing tables?

[Anonymous]

Hi @rzhuo6763 ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[HarishKM]

@rzhuo6763 Hello,
I am afraid that option is not available as of now to create a viz in power query but you can finish your all transformation then publish your dataset to power services and once you had published it you will generate insights of data over there.
or you can ask power bi to auto generate few report and you can change the visual as well there. Kindly follow below image.

Thanks
Harish M

[mussaenda]

Hi @rzhuo6763 ,

Power query is for ETL.

Not for charts. 

You need to create a visual and the columns will be updated according to your data.

If you want to create a visual by pushing a button, you can work around with bookmarks or buttons or page navigations. 

[Anonymous]

Hi @rzhuo6763 ,

Unfortunately the current version does not support.

If you would like to suggest  feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

You can manually create the pie chart in Power BI Desktop then place the columns on the appropriate fields, then you can update the data in power query and click close and apply, at which point the pie chart will automatically update.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[JadhavVarsha_13]

Hello @rzhuo6763 

You need to be in report view to create your visualizations.

If you are not there already, you need to navigate to this view by clicking the Report button along the left side of the window.

Add the Pie chart to the report

Click the Pie chart button in the Visualizations area.

Click the arrow to the left of the tables to expand the list of fields.

Using fields in Power BI visualizations is similar to how you work with PivotTables in Excel .

Drag the field from the table into the Legend area, and the fact field in the Values area.

There are plenty of formatting options that can be applied to a Pie chart to improve it.

Click the Format button to access all the formatting options for the selected visualization.

[rzhuo6763]

Hi @JadhavVarsha_13  Thank for you response. But I am wondering if I can do the above steps in a more automatic way? like in Power Query? The goal of the project is I can create some charts at the push of a button?

[JadhavVarsha_13]

you can also try this - https://learn.microsoft.com/en-us/power-bi/consumer/business-user-teams-create-reports