Power BI
How to create Power BI Charts

How to create Power BI Charts

Power BI is a visualization software available under the umbrella of Power Platform. It accepts data from a wide variety of data sources and the chart can be embedded into other Microsoft products or any Web apps. This post is for beginners who started out their journey in Power BI.

Navigate to Power BI site, it is the landing page for your tenant. Create a workspace it acts as a container for the reports we are going to create.

Open Power BI Desktop to start creating reports, First we need to connect the data. In this case we are using dataverse as datasource.

There will be two modes to play with the data

  1. Import – All the data will be loaded to Power BI. But there will be limitations on the report refresh and dataset size.
  2. DirectQuery – Live connection with the database. But there are very limited options to transform the data.

The environment domain for the database will be available in the admin center of PowerApps, Select the environment, copy and paste it into the environment domain.

Let’s start with import mode, Select your table from the environment and click Load. When the table is loaded, along with the report, a dataset will be created to handle the data.

Table Data

Transform Data is used to manipulate the data before it is passed into the report. For Eg: converting the values or getting data from two tables to merge it as one table. In this example, we changed the type from text to number.

Advanced Editor option shows the actual code behind the configuration, we can directly apply steps directly and it will be useful to change the environment while doing the environment migration.

Power BI Advanced Editor

Select a chart (we used bar chart for this example) from the right-hand side and map the X,Y axis. Based on the type of chart primary and secondary values can be passed. Chart customization can be done in the paint bar where the font size, color, title can be customized.

There are multiple options available to customize the values like we can show the sum, count, average of the selected axis. In this instance, we used count and sum and the Y-axis will change according to it.

Next, publish the chart in your workspace. Once published it will be available on the Power BI web.

Publish to Workspace

Follow the same steps to create a “Direct Query” report.

Direct Query

As already said certain operations will not work for “Direct Query” mode in Transform data. It will show a message to convert the dataset to import mode.

Based on our experience, “Direct Query” will be suited to dynamic applications where data volume is more and needs a constant refresh.

The report data can be sorted for the selected axis.

Sort option

Data refresh can be scheduled, If the data is to updated in a periodic manner refresh can be scheduled or if the refresh is disabled for the users and the system has to automatically refresh the report in such cases it will be useful.

Scheduled Refresh

The final step is to pin the report to a dashboard, this dashboard can be customized and can be embedded to other Microsoft products. We will see a detailed post in dashboard customization.

Dash Board

We have published a post to integrate Power BI in the Canvas app, Kindly have a look at it.

Please post your queries in the comment section. Happy Building šŸ™‚


Leave a Reply

%d bloggers like this: