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

32. Keyboard Shortcuts and DAX Cheat Sheet

32.1 Power BI Desktop Keyboard Shortcuts

By Last updated:

Press Shift + ? in Power BI Desktop to see the full shortcut list. The most useful ones:

General and canvas

Action Shortcut
Save / Undo / Redo Ctrl + S / Ctrl + Z / Ctrl + Y
Copy / Paste / Cut a visual Ctrl + C / Ctrl + V / Ctrl + X
Show ribbon key tips Alt
Move focus between sections (panes, canvas, ribbon) Ctrl + F6
Move focus forward / backward in a section Tab / Shift + Tab
Group selected visuals Ctrl + G
Open the Selection pane F6
Move object up / down in layering Ctrl + Shift + F / Ctrl + Shift + B
Hide / show selected object Ctrl + Shift + S
Zoom canvas in / out Ctrl + Plus / Ctrl + Minus
Move a visual (small / big steps) Arrow keys / Shift + Arrow keys
Show keyboard shortcuts Shift + ?

About this data: This table uses columns: Action, Shortcut. Values shown are the lesson examples already on this page (not a new dataset).

On a visual

Action Shortcut
Open the visual's menu (More options) Alt + Shift + F10
Show data (view the visual as a table) Alt + Shift + F11
Enter a visual / exit Ctrl + Right arrow / Esc
Clear selection Ctrl + Shift + C
Show or hide tooltip Ctrl + H
Multi-select data points Ctrl + Click (or Ctrl + Enter / Ctrl + Spacebar)
Test a button or bookmark in Desktop Ctrl + Click
Expand / collapse a matrix row Shift + Right arrow / Shift + Left arrow
Right-click menu Shift + F10

Data pane

Action Shortcut
Collapse all tables Alt + Shift + 1
Expand all tables Alt + Shift + 9

DAX formula bar

Action Shortcut
Commit formula Enter or Ctrl + Enter
New line below Shift + Enter (or Alt + Enter)
Comment / uncomment a line Ctrl + /
Show suggestions (IntelliSense) Ctrl + Space
Select next occurrence of selection Ctrl + D
Select all occurrences of selection Ctrl + Shift + L
Delete current line(s) Ctrl + Shift + K
Move line up / down Alt + Up / Down arrow
Copy line up / down Shift + Alt + Up / Down arrow
Indent / outdent line Ctrl + ] / Ctrl + [
Jump to matching bracket Ctrl + Shift + \
Go to line number Ctrl + G
Expand / collapse formula bar Ctrl + J
Increase / decrease font size Ctrl + Plus / Ctrl + Minus

Ravindra Bagale's Tip

Friends, many students learn fifty shortcuts and use none. Pick five you will use every day (for example Ctrl+S to save, Ctrl+C and Ctrl+V to copy visuals, and Ctrl+click to test buttons in Desktop) and practise them until they become a habit. Shortcuts can differ between versions and keyboard layouts, so check them in your own Desktop. Never forget this.

Deepen this topic (Why / What / How)

Fictional Maharashtra practice. Shortcut lists can differ by Desktop version — verify in your build.

Why: Mouse-only report building is slow in interviews and Friday demos.

What: A small set of Desktop shortcuts you actually use: file, canvas, copy visuals, model view, DAX bar.

How — train five daily shortcuts:

Vertical steps (one under another)

  1. Ctrl+S save every few minutes — habit before shortcuts ego.
  2. Ctrl+C / Ctrl+V copy visuals; Ctrl+Shift+C / V copy formatting where supported.
  3. Ctrl+click a button to test action without leaving edit.
  4. Use Tab / Shift+Tab to move focus; Esc to clear selection.
  5. Open View → Keyboard shortcuts list in your Desktop build and tick five favourites.
  6. Practise the five until muscle memory beats the mouse.

Tiny example: Fictional: Raja copies four KPI cards with Ctrl+C/V, aligns, saves with Ctrl+S before publish.

Ravindra Bagale's Tip

Friends, five shortcuts used daily beat fifty memorised once.

Sample shortcut habit ladder
Sample layout — fictional habit ladder

File and canvas shortcuts that matter

Vertical points

  1. Ctrl+N new, Ctrl+O open, Ctrl+S save, Ctrl+Shift+S save as (verify on your build).
  2. Ctrl+Z / Ctrl+Y undo redo — safer than rebuilding a visual.
  3. Delete/Backspace removes selected visual; Esc clears selection.
  4. Hold Ctrl to multi-select visuals for align/distribute.
  5. F5 or View refresh habits: refresh visuals after model changes when needed.

Model and DAX entry shortcuts

Vertical points

  1. Enter Model view to manage relationships with keyboard focus on diagram.
  2. In formula bar, Shift+Enter for new line in measures (common pattern).
  3. Tab to indent DAX for readability — interviewers notice clean measures.
  4. Esc cancels an in-progress formula edit carefully — confirm on your version.
  5. Name measures in the Properties pane without hunting the mouse every time.

Go deeper next

Use this chapter for speed. For DAX mastery open Ch 45–Ch 48; performance Ch 49.

Worked habit drill (fictional)

Why: Reading shortcuts without a drill does not create speed.

What: A 12-minute drill you can repeat every Monday.

How — run the drill:

Vertical steps (one under another)

  1. Open a throwaway .pbix (never Prod).
  2. Minutes 0–3: Ctrl+S after every change; count saves.
  3. Minutes 3–6: build 4 cards; copy with Ctrl+C/V; align.
  4. Minutes 6–9: add a button; Ctrl+click to test action.
  5. Minutes 9–12: undo/redo path; Esc clear; delete one spare visual.
  6. Write which two shortcuts still felt slow — practise only those tomorrow.

Tiny example: Fictional Raja logs “Ctrl+click button still slow” and drills only that on Tuesday.

Ravindra Bagale's Tip

Friends, a timed drill beats a pretty screenshot of the shortcut list.

Quiz (5 questions)

1. Best shortcut habit to start with:

2. Ctrl+C / Ctrl+V in Desktop often:

3. Ctrl+click on a button is useful to:

4. Shortcut lists can differ by:

5. Cheat sheets replace deep DAX chapters:

Practice tasks (12) — hints only, no full answers

  1. Task. List your personal top 5 Desktop shortcuts and practise each 10 times.
    Hint: Include Ctrl+S and copy visual.
  2. Task. Multi-select three visuals and align them using keyboard + ribbon.
    Hint: Ctrl multi-select.
  3. Task. Copy a visual and its formatting to a new page.
    Hint: Check Ctrl/Ctrl+Shift variants on your build.
  4. Task. Open the in-product keyboard shortcuts pane and screenshot your OS layout.
    Hint: Versions differ.
  5. Task. Teach one shortcut to a friend in Marathi or Hindi.
    Hint: Keep key names in English.
  6. Task. Time yourself building 4 KPI cards with vs without shortcuts.
    Hint: Note minutes.
  7. Task. Write a 60s interview line about shortcut habits.
    Hint: Five daily > fifty memorised.
  8. Task. Create a phone note of shortcuts you refuse to forget.
    Hint: Max 7 lines.
  9. Task. Practise Esc / Delete safely on a throwaway page.
    Hint: Do not practise on Prod .pbix.
  10. Task. Navigate Model view focusing relationships without only hunting mouse.
    Hint: Use tab/focus where possible.
  11. Task. Map which shortcuts help before a live demo.
    Hint: Save, copy, undo.
  12. Task. Link one shortcut habit to faster Ch 28 project work.
    Hint: One sentence.

Ravi Sir's Cards for this lesson

Power BI Desktop keyboard shortcuts. Small time savings add up when you build reports every day.Revision card

मराठी cards