Useful Shortcuts for Power BI and Fabric

Power BI is a powerful tool for data visualization and analysis, but navigating through its various features and functionalities can sometimes be time-consuming. To enhance your productivity and make your workflow more efficient, Power BI offers several keyboard shortcuts. Whether you’re cleaning data, building visualizations, or customizing reports, these shortcuts can save you time and effort.

In this blog post, we’ll explore some of the most useful Power BI shortcuts that every user should know.

Frequently used shortcuts

To do this actionPress
Move focus between sectionsCtrl + F6
Move focus forward in a sectionTab
Move focus backward in a sectionShift + Tab
Select or clear selection of an objectEnter or spacebar
Multi-select objectsCtrl + spacebar
Keytips to navigate and select ribbon buttonsAlt

On visual

To do this actionPress
Move focus to visual menuAlt + Shift + F10
Show dataAlt + Shift + F11
Enter a visualCtrl + Right arrow
Enter a layerEnter
Exit a layer or visualEsc
Select or clear selection of a data pointEnter or spacebar
Multi-selectCtrl + Enter or Ctrl + spacebar
Right-clickWindows keyboard: Windows context key + F10. The Windows context key is between the Left Alt key and the Left Arrow KeyOther keyboard: Shift + F10
Clear selectionCtrl + Shift + C
Show or hide tooltipCtrl + H
Move a visual on the canvas (small moves)*Arrow keys (up, down, right, left)
Move a visual on the canvas (bigger moves)*Shift + arrow keys
Resize a visual*Arrow keys
Maintain aspect ratio*Shift + drag the resize handles
Group Visuals*Select visuals + Ctrl + G

Table navigation

To do this actionPress
Move focus up / down one cell (across all cells in all areas)Up arrow key / Down arrow key
Move focus left / right one cell (across all cells in all areas)Left arrow key / Right arrow key
Moves the focus to the last cell in the current rowCtrl + Right arrow key / End key
Moves the focus to the first cell in the current rowCtrl + Left arrow key / Home key
Moves the focus to the last element in the current columnCtrl + Down arrow key
Moves the focus to the first element in the current columnCtrl + Up arrow key
Moves the focus to the first element in the table (top left corner)Ctrl + Home key
Moves the focus to the last element in the table (bottom right corner)Ctrl + End key
Moves the focus to the last row displayed in the current columnPage down key
Moves focus to the first row displayed in the current columnPage up key
Selecting multiple noncontiguous rowsCtrl + Enter / Ctrl + Space
Selecting multiple contiguous rowsShift + Down arrow key or Up arrow key
Clear selected rowsCtrl + Shift + C
Open URL linksCtrl + Alt + O
Open Context MenuShift + F10

Matrix navigation

To do this actionPress
Expand matrixShift + Right arrow key
Collapse matrixShift + Left arrow key

Pane navigation

To do this actionPress
Multi-selectCtrl + Spacebar
Collapse a single tableLeft arrow key
Expand a single tableRight arrow key
Collapse all tablesAlt + Shift + 1
Expand all tablesAlt + Shift + 9
Open a context menuWindows keyboard: Windows context key + F10. The Windows context key is between the Left Alt key and the Left Arrow KeyOther keyboard: Shift + F10

Canvas zoom

To do this actionPress
Zoom inCtrl + Plus or Ctrl + (mouse scroll wheel forward)
Zoom outCtrl + Minus or Ctrl + (mouse scroll wheel backward)
Scroll canvas upPage up key
Scroll canvas downPage down key
Scroll canvas leftAlt + Page up key
Scroll canvas rightAlt + Page down key

Slicer

To do this actionPress
Interact with a slicerEnter
Move focus between menu itemsUp arrow key / Down arrow key
Move focus to first menu itemHome
Move focus to last menu itemEnd
Select multiple contiguous itemsShift + Up arrow key / Down arrow key
Open context menuShift + F10

Selection pane

To do this actionPress
Activate selection paneF6
Move up an object in the layeringCtrl + Shift + F
Move down an object in the layeringCtrl + Shift + B
Hide / show (toggle) an objectCtrl + Shift + S

DAX formula bar

To do this actionPress
SubmitCtrl + Enter or Enter
Go to line numberCtrl + G
Move line up / downAlt + Up arrow key / Down arrow key
Copy line up / downShift + Alt + Up arrow key / Down arrow key
Insert line belowShift + Enter or Alt + Enter
Insert line aboveCtrl + Shift + Enter
Delete selected wordCtrl + Del
Delete all selected linesCtrl + Shift + K
Jump to matching bracketCtrl + Shift + \
Jump to start of a line of codeCtrl + Home
Jump to the end of a line of codeCtrl + End
Indent line / Extend line into the marginCtrl + ] or Ctrl + [
Insert cursorAlt + Click
Select current lineCtrl + L
Select all occurrences of current selectionCtrl + Shift + L
Select all occurrences of current wordCtrl + F2
Select next occurrences of current selectionCtrl + D
Select the line aboveShift + Up arrow key
Select the line belowShift + Down arrow key
Enter multiple lines of code up / downCtrl + Alt + Up arrow key / Down arrow key
Comment a lineCtrl + / or Ctrl + K + C
Uncomment a lineCtrl + / or Ctrl + K + U
Increase font sizeCtrl + + or Scroll Up
Decrease font sizeCtrl + – or Scroll Down
Show or hide “Read more” tooltipsCtrl + I
Show accessiblity widgetAlt + F1
Close widget, suggestions, other dialogs, or closes DAX formula barEsc
Show suggestionsCtrl + Space
Expand or Collapse DAX formula barCtrl + J
Focus on the DAX fomula bar itself to tab to next UI elementCtrl + M

Enter data

To do this actionPress
Exit editable gridCtrl + Tab

Model view navigation

To do this actionPress
Move focus to first card in relationship diagramTab
Move focus to the next cardTab / Right arrow key / Down arrow key
Move focus to the previous cardShift + Tab / Left arrow key / Up arrow key

On card in model view

To do this actionPress
Move focus to relationship line connected to cardCtrl + Alt + R
Move focus to first field list item on the cardEnter
Move focus to next item within the cardTab
Move focus back to entire cardEsc
Open context menuShift + F10
Move focus to the next field list itemRight arrow key / Down arrow key
Move focus to the previous field list itemUp arrow key / Left arrow key

On relationship in model view

To do this actionPress
Move focus to next card connected to relationship lineCtrl + Alt + R
Move focus to previously focused card connected to relationship lineShift + Alt + R
Open relationship properties paneEnter
Move focus to next relationship line connected to cardTab / Right arrow key / Down arrow key
Move focus to previous relationship line connected to cardShift + Tab / Left arrow key / Up arrow key
Select focused relationshipEnter

Mastering these Power BI keyboard shortcuts will significantly enhance your productivity, allowing you to navigate, edit, and interact with your data more efficiently. Whether you are new to Power BI or an experienced user, integrating these shortcuts into your workflow will help you get the most out of your data analysis and reporting tasks.