Forum Discussion
create charts with power query
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.
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?