Power BI


What is Power BI

Data Preprocessing

Get Data

Click on More and get more data source

Fields on the right side

Support CSV file transformation

Queries on the left side

After filter the data you need, and delete the data you don’t need.
Click on Close & Apply on the top and left.

Data Visualization

Then we get the data after cleansing

Click on Model button on the left.

Drag the table to rearrange

Drag the column

Type to query

Connect the same filed among plural tables if you need

Format your column

Categorize the column

Gauge Chart

Click on Insert, then insert a gauge chart


Select your visualization type, then select a field, e.g, KPI

Drag data to KPI: Indicator

Drag data to KPI: Target goals

Line Chart

Adjust the details

You could also add measure

Then add the formula



Add slicer ‘Jun 2020 YTD’


Choose different theme

Click on Browse for themes to load themes, e.g, JSON file

Click on the data you are interested in to use the built-in interactive features for highlighting the data


Right click the chart and click on Analyze to see explain

And you can change the analysis chart type


You can change the icon to the matrix data for highlighting


Map visualization

Decomposition Tree

Add fields to Analyze and Explain by

Decomposition Tree: Choose by yourself

Power BI Service

Publish your visualization

Click on Publish

Choose a workspace


Review your visualization online

Go to your Power BI web

Select the report

You can interact with the dashboard

Focus Mode

You can focus on a chart

You can filter data on Focus mode.
As a user, any filter you added won’t be saved.

Show as table

The chart will be showed on top, and below is table


You can also use analyze tools in viewer mode

Pin to a dashboard

During dashboard mode, no tools available except Ask a question

Suggested question

Or ask a question by yourself


Share report

Embed report

Data Refresh

Schedule Refresh