• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Score Bar Chart
      • CSAT Score Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact Us
      • FAQs
      • Resources
    • Accessible Support

      for Your Journey

Categories
All Data Visualizations Data Analytics Data Stories
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics
Data Stories
  • Healthcare
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok

ChartExpo Survey



Home > Blog > Data Visualization > Add-ons > Power BI >

How to Use Power BI to Create Charts?

You might wonder how to use Power BI if you are accustomed to spreadsheets in Excel. Power BI (PBI) is a much more powerful data analysis tool.

How to use Power BI

You need to understand its features and the kind of data visualizations that you have access to. This way, you can utilize it effectively.

Most importantly, you need to ensure that you work with good-quality data. A powerful tool is not a replacement for bad data.

You also need to ensure that you work with data in the correct format. Access and permissions should also be granted carefully.

Defining your data points and KPIs will also make it easier to work with PBI.

In this article, we learn how to use Power BI and define it. We’ll discuss core PBI features and, finally, how to use PBI to create charts for data analysis.

Table of Content:

  1. What is Microsoft Power BI?
  2. Core Features of Power BI
  3. How to Use Power BI to Create a Chart for Data Analysis?
  4. Wrap Up

What is Microsoft Power BI?

Microsoft Power BI is a business analytics service created by Microsoft. It enables users to visualize and analyze data in a user-friendly way.

Users can also create informative and interactive data visualizations using a wide range of data sources.

Power BI can help businesses make data-driven decisions. This is because you can garner critical insights from your data.

The platform is designed for non-technical users as well as data professionals. This makes it accessible to a wide range of users.

Learning how to use Power BI helps you analyze data from a variety of sources, including:

  • Excel spreadsheets,
  • databases,
  • cloud-based and on-premises data sources,
  • and other third-party applications.

Core Features of Power BI

Here are the most important Power BI features you need to know to get started with PBI:

  • Data Visualizations

Data visualization is arguably one of the most popular Power BI features.

With PBI, you can create compelling and interactive visualizations like:

    • Charts
    • Tables
    • Maps
    • Gauges

Data visualizations help present data in a clear and concise manner.

  • Data Modeling

Data modeling allows you to create relationships between data sources. You can also define calculated columns and measures and create hierarchies.

  • Customizable Templates

Power BI provides templates to quickly create Power BI reports and dashboards. There are a variety of templates, for example, for financial analysis, sales tracking, and marketing analytics.

When you learn how to use Power BI, you can customize templates to fit your use case.

  • Dashboards

You can create Power BI dashboards to provide an overview of KPIs and other metrics. Dashboards can be shared and accessed from multiple devices.

  • Collaboration

Power BI supports collaboration, allowing teams to work together on reports and dashboards. Users can also share content with others within the organization or externally.

  • Accessibility

Power BI provides mobile apps for iOS, Android, and Windows devices. This allows for access to reports and dashboards from anywhere.

  • Data Integration

One great Power Bi feature is that you can integrate it with other tools and applications. This allows users to easily import data and use it to create reports and dashboards.

Some of the tools you can integrate with PBI include Excel, SharePoint, and Dynamics 365.

How to Use Power BI to Create a Chart for Data Analysis?

In this section, we learn how to use Power BI to create a chart for data analysis.

Stage 1: Logging in to Power BI

  • Log in to Power BI.
  • Enter your email. Click the “Submit” button.
spend report analysis
  • Enter your password and click “Sign in“.
submit button
  • Choose whether to stay signed in.
enter password to Power BI

Stage 2: Create a Data Set and Select the Data Set to Use in Your Sankey Chart

  • Click on the “Create” option on the left-side menu.
  • Select ”Paste or manually enter data“.
Manually enter data
  • The following cash flow data will be used for this example.
Total Cost Company Type Company Name Expertise Categories Expertise Cost
Total Cost Subcontractor Skyline Contractors Mechanical Installation Plumbing & Heating 15456
Total Cost Subcontractor Skyline Contractors Mechanical Installation Mechanical Work 10159
Total Cost Subcontractor Onyx General Contractors Mechanical Installation Plumbing & Heating 18045
Total Cost Subcontractor Onyx General Contractors Mechanical Installation Mechanical Work 12695
Total Cost Subcontractor Living Well Remodeling Mechanical Installation Plumbing & Heating 14589
Total Cost Subcontractor Living Well Remodeling Mechanical Installation Welding 11456
Total Cost Supplier Power-up Builders Raw Material Cement 20561
Total Cost Supplier Power-up Builders Raw Material Steel 32456
Total Cost Supplier Five-star Construction Raw Material Bricks 10253
Total Cost Supplier Five-star Construction Raw Material Timber 9000
  • Paste the above data table into the “Power Query” window.
  • Select the “Create a dataset only” option.
Create a dataset only
  • Click on the “Data Hub” option on the left-side menu.
  • Power BI populates the data set list. (If you have not created a data set, refer to the Error! Reference source not found section.)
Data Hub
  • Choose the data set you want to use to create your Sankey diagram.
  • Power BI populates the screen as shown below:
create report in power bi
  • The data set and its fields are shown on the right side. The middle area shows report and data set options.
  • Click on the “Create a report” dropdown.
  • Select “Start from scratch“.
  • You should see the Report Canvas screen as shown below:
Start from scratch

Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo

  • To finish creating our Sankey Diagram, we’ll use an add-in or Power BI visual from AppSource.
  • Navigate to the Power BI Visualizations panel.
  • Click the ellipsis (…) highlighted above to import the Power BI Sankey Diagram extension by ChartExpo.
Power BI visual from
  • The following menu opens:
  • Select the “Get more visuals” option.
Get more visuals
    • The following window opens.
    • Enter “Sankey Diagram for Power BI by ChartExpo” in the highlighted search box.
  • You should see “Sankey Diagram for Power BI by ChartExpo” as shown in the image below.
Sankey Diagram for Power BI by ChartExpo
  • Click the highlighted “Add” button.
create Sankey Diagram for Power BI by ChartExpo
  • Power BI will add the “Sankey Diagram for Power BI by ChartExpo” icon in the visualization panel.
icon in the visualization panel

Stage 4: Drawing a Sankey Diagram with ChartExpo’s Power BI extension

  • Select the “Sankey Diagram for Power BI by ChartExpo” icon in the visualization panel.
  • The following window opens in the report section of your dashboard:
select sankey chart in power bi
  • You can resize the visual as needed.
  • Navigate to the right side of your Power BI dashboard. You should see “Fields” next to “Visualizations“.
select fields
  • You’ll select the fields to use in your Sankey chart here.
  • The ChartExpo visual needs to be selected, though.
  • Select the field in the following sequence:
    • Total Cost
    • Company Type
    • Company Name
    • Expertise Categories
    • Expertise
    • Cost
select fields power bi
  • You’ll be asked for a ChartExpo license key or email address.
ChartExpo license key

Stage 5: Activating your ChartExpo Trial or Applying a Subscription Key

  • Select the ChartExpo visual. You should see three icons below “Build Visual” in the Visualizations panel.
Build visual
  • Select the middle icon, “Format visual“.
  • The visual properties will be populated as shown below.
format visual
  • If you are a new user:
    • Enter your email address in the “Email” textbox in the “Trial Mode” section.
    • This should be the email address that you used to subscribe to the ChartExpo add-in. It is where your ChartExpo license key will be sent.
    • Ensure that your email address is valid.
    • Click “Enable Trial.” You’ll get a 7-day trial.
Enable Trial
  • You should receive a welcome email from ChartExpo.
  • The Sankey Diagram you create under the 7-day trial contains the ChartExpo watermark (see below).
ChartExpo watermark
  • If you have obtained a license key:
    • Enter your license key in the “ChartExpo License Key” textbox in the “License Settings” section (see below).
    • Slide the toggle switch next to “Enable License” to “On“.
License Settings
  • Your Sankey diagram should now be ready (see below). Note that it does not have a watermark.
sankey chart in power bi
  • Let’s add the prefix (e.g., the $ sign) to the numeric values in the chart.
  • Expand the “Stats” properties.
  • Add the prefix value (e.g., the $ sign).
expand stats
  • To add colors, expand the “Level Colors” properties and select a color.
  • Do this to change the color of each node.
sankey visual in power bi
  • Automatically, all changes will be saved.
sankey graph in power bi

Insights

  • At level 1, the total cost of the procurement is $155K.
  • At level 2, $72.3K (46.7%) was spent on suppliers. $82.4K was spent on subcontractors, which is 53.3%.
  • At Level 3, Power-up Builders and Five-Star Construction charged $53.0k and $19.3k, respectively. While $82.4k in subcontractors’ costs was spent on 3 companies:
    • Skyline Contractors,
    • Onyx General Contractors,
    • and Living Well Remodeling.
  • They charged $25.62k, $30.7k, and $26.0k respectively, for their services.
  • At Level 4, suppliers provided raw materials for procurement, which cost $72.3k. Companies that provided mechanical installations billed $82.4k.
  • $72.3k was spent on purchasing raw materials. It was split between cement ($20.6k), steel ($32.46k), bricks ($10.3k), and timber ($9k), respectively. $82.4k was spent on mechanical installation costs. It was split between plumbing, heating, mechanical work, and welding. Their costs were $48.1k, $22.9k, and $11.5k, respectively.

FAQs:

What is Power BI, and why is it used?

Microsoft Power BI is a business analytics service. It is used to find insights within an organization’s data. It helps connect disparate data sets and transform and clean the data into a data model.

Knowing how to use Power BI helps you create charts or graphs to visually represent the data. The visualizations can be shared with other Power BI users within the organization and externally.

What is an example use case for Power BI?

Power BI is a powerful business analytics tool. It can be used for a variety of purposes in different industries. Some of the common Power BI use cases are:

  • Creating interactive Power BI reports and dashboards
  • Tracking various metrics and KPIs
  • Data analysis
  • Creating data visualizations like bar charts, line charts, scatter plots, pie charts, tables, and maps

Wrap Up

Power BI is one of the most powerful business intelligence tools for analyzing and visualizing data.

Our main focus throughout this article has been learning how to use Power BI. To do this, we went through the process of using it to create a data analysis chart.

We used the ChartExpo add-in from AppSource to help us create our chart.

We also looked at what Power BI is and briefly discussed its core features. The most important features include data visualizations, customizable templates and dashboards, and data integration.

Finally, we answered some FAQs. We hope you are ready to explore and learn how to use Power BI.

How much did you enjoy this article?

chartexpo ad
chartexpo ad
chartexpo ad
chartexpo ad
126144

Related articles

next previous
Power BI10 min read

How to Leverage Power BI Data Model for Analytics?

Learn how to optimize your Power BI data model for maximum performance and use data sets to create impactful charts in Power BI.

Power BI9 min read

Mastering Data Visualization: A Guide to Power BI in Office 365

Unlock Data Insights with Power BI in Office 365. Harness the combined potential of Power BI and the collaborative prowess of Office 365.

Power BI9 min read

Power BI Data Connectors: Your Gateway to Data Insights

Explore a wide range of Power BI connectors. Seamlessly integrate and visualize data. Enhance your analytics experience.

Power BI11 min read

What are the Main Features of Power BI Pro?

Supercharge your data analytics and visualization capabilities with Power BI Pro. Collaborate, share, and derive actionable insights from your data like never before.

Power BI10 min read

The Art of Storytelling with Power BI Dashboards Design

Discover the importance of beautiful Power BI dashboard design and learn best practices to create appealing and impactful dashboards using Power BI.

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Score Bar Chart
  • CSAT Score Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2023 ChartExpo, all rights reserved.