Ravindra BagaleCourses & study guides मराठी Track your progress

2. Installation and Interface Tour

2.3 The Ribbon

By Last updated:

Start with a problem

Shahrukh spends five minutes hunting for New measure and Performance analyzer in the ribbon.

Explain simply

The ribbon groups buttons into tabs: Home (data, refresh, publish), Insert (pages, visuals, buttons), Modeling (measures, relationships, roles), View (themes, panes), Optimize (performance), Help, plus contextual tabs that appear when you select something.

Show the data

Task Tab you need
Create Total Sales measure ?
Open the Performance analyzer ?
Turn on the Bookmarks pane ?
Type a small targets table ?

About this data: This table uses columns: Task, Tab you need. This table uses columns: Data pane. This table uses columns: Card. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).

Demonstrate

  1. Home › Enter data › type City/Target: Pune 1,000; Nashik 900; Kolhapur 500 › name Targets › Load.

    Your result should look like this:

    Data pane
    Targets (3 rows)

  2. Modeling › New measure › Total Sales = SUM(Orders[Amount]).

    Your result should look like this:

    Card
    ₹2,100

  3. View › tick Bookmarks.

    Your result should look like this:

    Pane
    Bookmarks opens on the right

  4. Optimize › Performance analyzer › Start recording.

  5. Select a visual and notice the contextual Format and Data/Drill tabs.

Show the result

Your result should look like this (fictional sample):

Task Tab
Create Total Sales measure Modeling (or Home)
Open the Performance analyzer Optimize
Turn on the Bookmarks pane View
Type a small targets table Home › Enter data

Explain what happened

Each tab holds one family of tasks. Right-clicking a field or visual often gives the same command faster.

Explore further

  • Targets total ₹2,400; actual ₹2,100 is 87.5% of target (Module 13 builds this measure).

Detailed reference for this lesson:

The ribbon at the top works just like in Excel. The main tabs are:

Tab Important buttons
Home Get data, Recent sources, Enter data, Transform data (opens Power Query), Refresh, New visual, Text box, New measure, Publish
Insert New page, New visual, Buttons, Shapes, Image, Text box, Smart narrative, Q&A
Modeling New measure, New column, New table, Manage relationships, Manage roles, View as, New parameter (Numeric range / Fields)
View Themes, Page view, Mobile layout, Gridlines/Snap to grid, panes (Filters, Bookmarks, Selection, Sync slicers)
Optimize Pause visuals, Optimization presets, Performance analyzer
Help Documentation, training, community links
Contextual tabs Appear only when needed: Format and Data/Drill when a visual is selected; Table tools, Column tools, Measure tools in Table view or when a field is selected

Ravindra Bagale's Tip

A common mistake is hunting through ribbons for a button when the right-click menu is faster. Right-click a column, a visual or a table first. Most everyday actions (rename, new measure, sort, refresh) are there. Try it once more, then move on.

Fix common mistakes

Wrong result Reason Correction
Can't find Format tab Contextual tabs appear only when a visual is selected Select the visual first
Measure created in the wrong table The selected table is the home table Select Orders first, or change Home table in Measure tools
Enter data table has text numbers Type not set Set Target to Whole number in the Enter data dialog or Power Query

Practise independently

Practice task

Using the Targets table you typed, what percentage of target did Nashik reach?

Hints
  • Nashik actual ₹800, target ₹900.
Solution

₹800 ÷ ₹900 = 88.9%.

Think like a professional

Learn the right-click menus and three shortcuts you use daily; the ribbon is for things you do rarely.

Ravi Sir's Cards for this lesson

The ribbon in Power BI Desktop. Hunting for buttons wastes time. Knowing the tabs makes you faster.Revision card

मराठी cards