Core public administration (CPA) employment trends and demographics

From: Treasury Board of Canada Secretariat

Find public service employment trends and demographic statistics as well as reference data pertaining to employment equity workforce availability benchmarks through our interactive tool. Explore, manipulate and filter data about the core public administration using charts and tables.

  1. Choose the report you want to explore
  2. Select the filters you want to apply
  3. Analyze and/or export the data
Instructions on how to navigate the tool with keyboard shortcuts

Here are the keyboard shortcuts that allow users to navigate within the interactive data visualization tool.

On visual

For each term provided for To do this
For each definition the keyboard shortcuts are accomplished byPress
Move focus to visual menu
Alt + Shift + F10
Show data
Alt + Shift + F11
Enter a visual
Ctrl +   
Enter a layer
Enter
Exit a layer or visual
Esc
Select or unselect data point
Enter or Space
Multi-select
Ctrl + Enter or Ctrl + Space
Right click
Windows keyboard:    + F10. The Windows context key is between the Left Alt key and the Left Arrow Key
Right click alternative
Other keyboard: Shift + F10
Clear selection
Ctrl + Shift + C

Table and matrix navigation

For each term provided for To do this
For each definition the keyboard shortcuts are accomplished by Press
Move focus up / down one cell
   /    across all cells in all areas
Move focus left / right one cell
   /    across all cells in all areas

Pane navigation

For each term provided for To do this
For each definition the keyboard shortcuts are accomplished by Press
Multi-select
Ctrl + Space
Collapse a single table
  
Expand a single table
  
Collapse all tables
Alt + Shift + 1
Expand all tables
Alt + Shift + 9
Open a context menu
Windows keyboard:    + F10. The Windows context key is between the Left Alt key and the Left Arrow Key
Open a context menu alternate
Other keyboard: Shift + F10

Frequently used shortcuts

For each term provided for To do this
For each definition the keyboard shortcuts are accomplished by Press
Enter Power BI report
Ctrl + Enter
Move focus between sections
Ctrl + F6
Move focus forward in section
Tab
Move focus backward in section
Shift + Tab
Select or de-select an object
Enter or Space
Multi-select objects
Ctrl + Space

Microsoft Help

More information on Power BI can be found on the Microsoft website (https://docs.microsoft.com/en-ca/power-bi/consumer/). Note that not all features of Microsoft Power BI are available in our interactive tool.

Employment trends by tenure

Date modified: