How to Create a Chart in Power BI

Trending 1 week ago

Transform your information into compelling ocular stories pinch charts successful Power BI.

White bars casted successful a achromatic background

A well-crafted floor plan communicates accusation effortlessly to your audience. Luckily, creating a floor plan successful Power BI is comparatively easy.

You tin create charts by simply dragging and dropping your ocular connected nan canvas. Here are nan different kinds of Power BI charts and really to create them.

Types of Charts successful Power BI

Power BI offers a divers scope of visualization options. The bully point is that astir of nan graphs and charts successful Microsoft Excel tin each beryllium created successful Power BI. If you're unfamiliar pinch charts, you tin get to cognize them by creating graphs and charts successful Excel.

All nan various floor plan icons successful Power BI Visualization

You tin spot nan various floor plan types successful nan Visualization pane of your Power BI report. The floor plan types successful Power BI see area charts, statement charts, barroom and file charts, combo charts, pastry charts, cards, decomposition trees, ribbon charts, scatter charts, doughnut charts, maps, and overmuch more.

1. Import Your Data into Power BI

You request to import your information earlier you tin create charts successful Power BI. If you haven't prepared your information yet, you tin believe pinch information from websites that supply free data. In our case, we'll activity pinch information connected Cocoa accumulation by country. You tin download this dataset successful CSV format from nan World Population Review website.

Once you person your data, you'll request to load it into Power BI. Here's really you tin do that:

  1. Open Power BI.
  2. Click connected nan Home menu.
  3. Click connected nan Get data action and prime Excel.
    This images shows nan Get information page of Power BI
  4. Locate and prime nan record from your section directory.
    Data preview successful Power BI
  5. A preview of nan information will beryllium displayed successful Power BI Navigator. Select Load Data if you are satisfied pinch really nan record looks.

If you're unhappy pinch nan data, you tin usage Power Query to cleanable and toggle shape nan data. Luckily, nan sample information successful our lawsuit is successful bully condition.

2. Create a Bar Chart successful Power BI

Regardless of nan floor plan type, nan process of adding a visualization to your Power BI canvas is nan same. Let's create a barroom floor plan successful Power BI to footwear things off. Once you've loaded your data, travel nan steps below:

  1. Head to nan Visualization pane.
  2. Click connected nan stacked barroom floor plan ocular from nan Visualization pane.
    The Power BI study visualization showing nan stacked barroom floor plan icon
  3. Drag and driblet nan country file from nan Data pane into nan Y-axis field.
  4. Similarly, resistance and driblet nan pop2023 file from nan Data pane into nan X-axis. This will automatically populate nan barroom floor plan pinch data.
    A study pinch a bluish barroom Power BI barroom chart
  5. Click connected nan Format Your Visual icon to customize your charts.
    A Power BI study pinch bluish bars charts

There are plentifulness of ways to customize your chart. For instance, you tin alteration nan colour of nan barroom floor plan nether nan color action of nan Bar drop-down arrow.

3. Create a Pie Chart successful Power BI

Pie charts are effective for illustrating proportions wrong your data. You tin create a pastry floor plan utilizing nan aforesaid approach:

  1. Select nan Pie floor plan visual from nan Visualization pane.
  2. Drag and driblet your country file from nan Data pane into nan legend. This represents nan information keys for nan visual.
  3. Drag and driblet your pop2023 column from nan Data pane into nan worth option. This will populate nan pastry chart.
A Power BI Pie floor plan that shows nan apical cocoa producing countries successful nan world

Create Powerful Charts successful Power BI

Power BI empowers you to return your visualization crippled to nan adjacent level by offering awesome visuals and features. With Power BI, you tin trade aesthetically appealing and interactive reports while giving your assemblage a amended knowing of nan data.

This level of interactivity transforms earthy information into compelling, easy-to-understand ocular stories that tin maximize your data's potential.

Source Tutorials