Power BI Interface Overview

Power BI · Power BI Introduction

Theory

Power BI Desktop has a ribbon on top, a set of views on the left and panes on the right. Report view is the canvas where you place visuals. Table view (called Data view in older versions) shows the loaded rows of each table so you can check values and create calculated columns. Model view shows tables as boxes with relationship lines between them. DAX query view lets you write and run DAX queries against the model, and TMDL view shows the semantic model as a script you can edit and apply.

On the right in Report view sit the Visualizations pane (pick a visual and drop fields into its wells), the Data pane (called Fields in older versions, listing tables, columns and measures) and the Filters pane (visual, page and report-level filters). For example, to chart sales by region you click the bar chart icon, drag Region to the Y-axis well and [Total Sales] to the X-axis well.

Why we use it

Knowing where each tool lives saves a lot of time and makes tutorials easy to follow. Most beginner confusion, such as 'where do I create a relationship?', is just not knowing which view to open.

When to use it

Use Report view to design, Table view to verify data and calculated columns, and Model view for relationships, hiding fields and properties. Use the Power Query Editor (Home → Transform data), not Table view, when you need to change the data itself.

How it works

  1. Open Power BI Desktop
  2. Load data with Home → Get data
  3. Need to fix or reshape the data? Yes: Open Power Query via Transform data. No: Go straight to Model view.
  4. Create relationships in Model view
  5. Write measures and build visuals in Report view
  6. Save the .pbix file

Syntax

Left rail: Report | Table | Model | DAX query | TMDL views
Right panes (Report view): Visualizations | Data | Filters
Ribbon: Home → Get data / Transform data / New measure / Publish

Example

1. Report view: click Clustered bar chart in the Visualizations pane.
2. Data pane: drag Sales[Region] to Y-axis and [Total Sales] to X-axis.
3. Filters pane: add Products[Category] = "Electronics" as a page filter.
4. Table view: open Sales and confirm Amount is a whole number.
5. Model view: check the one-to-many line from Customers to Sales.

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic