HR & people · Power BI template

Learning & Training Compliance Power BI template

Power BI training compliance template: mandatory training vs a 95% target, overdue assignments, completions by month, learning hours and scores.

By · Founder & Reliability Engineer · Updated

Free for commercial use

Dark version: same layout, colours re-solved and checked for WCAG AA contrast.

Learning & Training Compliance Power BI dashboard template: 4 KPI cards, a gauge, a bar chart, a column chart, a donut chart, a table and 2 slicers on a 1280×720 page

BetaOpens in Power BI Desktop with 4 tables of sample data and every visual bound. See what’s inside

Free, no sign-up. The PBIP with sample data includes the background, theme and a README. 1920×1080 fits a new page in a Fluent 2 report; 1280×720 and 2× fit Classic pages. Downloads carry a small “Made with VizForge” mark (sign in to the studio to remove it).

Customise in the design studio →
Layout
Left nav rail, compliance gauge + 4 KPIs, department bars + monthly completions, delivery donut + overdue table
Page size
1280×720 px (16:9, Power BI default)
Theme
Arctic Teal

Open the sample-data PBIP in Power BI Desktop

Checked against Microsoft Learn's Power BI Desktop projects documentation (as of Nov 2026).

  1. 1

    Unzip to a short path and open the .pbip

    Extract the zip to a short local folder such as C:\PBI (Windows limits project paths to 260 characters, and Desktop can't save a project straight to OneDrive or SharePoint), then double-click the .pbip file or use File → Open in Power BI Desktop. Microsoft still lists projects and TMDL as preview features (as of Nov 2026): if Desktop won't open the project, go to File → Options and settings → Options → Preview features, tick “Power BI Project (.pbip) save option” and “Store semantic model using TMDL format”, then restart Desktop.

  2. 2

    Select Refresh once

    The project ships without the local data cache (.pbi/cache.abf), so Desktop opens the full model definition without data. Select Home → Refresh: every table is built from values written into its Power Query step, so there is no data source to sign in to.

  3. 3

    Save as .pbix or connect your data

    Use File → Save as to keep a single .pbix file, or open Transform data and replace each table's Source step with your own query, keeping the column names so the measures and visuals keep working.

What’s inside the Training sample model

Rendered from the same definition the download writes as TMDL, so this list always matches the file.

Tables
4
Fact rows
480
DAX measures
8

Training records at a fictional 450-person company from January to October 2026: 480 course assignments across six mandatory compliance courses and six development courses, with due dates, completion dates, assessment scores and days overdue at 31 Oct 2026; department headcount gives learning hours per employee. Units: Assignments; learning hours; assessment scores out of 100.

Tables and columns

Calendar

Date table · 2026, one row per day

Date table generated in Power Query (List.Dates), marked as the model's date table.

  • Date (date)
  • Year (whole number)
  • Quarter (text)
  • Month (text)
  • Month Name (text)
  • Week Start (date)
  • Weekday (text)
  • Fiscal Year (text)

Department

Dimension · 6 rows

Departments with headcount.

  • Department (text)
  • Headcount (whole number)

Course

Dimension · 12 rows

Courses with type, delivery mode and duration.

  • Course (text)
  • Course Type (text)
  • Delivery Mode (text)
  • Hours (decimal)

Assignments

Fact · 480 rows

One row per course assigned to an employee (anonymous IDs). The Calendar relates to the completion date.

  • Assignment ID (text)
  • Employee ID (text)
  • Department (text)
  • Course (text)
  • Assigned Date (date)
  • Due Date (date)
  • Completed Date (date)
  • Status (text)
  • Score (whole number)
  • Days Overdue (whole number)

Relationships

Many-to-one, single direction. Inactive relationships are switched on inside a measure with USERELATIONSHIP.

  • Assignments[Completed Date] → 'Calendar'[Date]
  • Assignments[Department] → Department[Department]
  • Assignments[Course] → Course[Course]

DAX measures

All measures live in a dedicated Key Measures table. Copy any of them into your own model; rename the table and column references to match.

CompletionsCourses completed (by completion date).
Completions =
CALCULATE ( COUNTROWS ( Assignments ), Assignments[Status] = "Completed" )

Format string: #,0

Overdue AssignmentsAssignments past their due date and not completed.
Overdue Assignments =
CALCULATE ( COUNTROWS ( Assignments ), Assignments[Status] = "Overdue", REMOVEFILTERS ( 'Calendar' ) )

Format string: #,0

Mandatory Compliance %Mandatory assignments completed, of those completed or overdue.
Mandatory Compliance % =
VAR Done = CALCULATE ( COUNTROWS ( Assignments ), Course[Course Type] = "Mandatory", Assignments[Status] = "Completed", REMOVEFILTERS ( 'Calendar' ) )
VAR Late = CALCULATE ( COUNTROWS ( Assignments ), Course[Course Type] = "Mandatory", Assignments[Status] = "Overdue", REMOVEFILTERS ( 'Calendar' ) )
RETURN
    DIVIDE ( Done, Done + Late )

Format string: 0.0%

Compliance TargetMandatory training target.
Compliance Target =
0.95

Format string: 0%

Learning HoursHours of completed training.
Learning Hours =
SUMX ( FILTER ( Assignments, Assignments[Status] = "Completed" ), RELATED ( Course[Hours] ) )

Format string: #,0

Learning Hours per EmployeeCompleted training hours per head.
Learning Hours per Employee =
DIVIDE ( [Learning Hours], SUM ( Department[Headcount] ) )

Format string: 0.0

Avg Assessment ScoreAverage end-of-course assessment score.
Avg Assessment Score =
AVERAGE ( Assignments[Score] )

Format string: 0

Days OverdueDays past the due date.
Days Overdue =
MAX ( Assignments[Days Overdue] )

Format string: 0

What each visual is bound to

The PBIP opens with these fields already on each visual.

Field bindings per visual
VisualFields
DepartmentSlicerDepartment[Department]
Course typeSlicerCourse[Course Type]
Mandatory complianceGauge[Mandatory Compliance %], [Compliance Target]
Overdue assignmentsCard[Overdue Assignments]
CompletionsCard[Completions]
Learning hours per employeeCard[Learning Hours per Employee]
Avg assessment scoreCard[Avg Assessment Score]
Compliance by departmentBar chartDepartment[Department], [Mandatory Compliance %]
Completions by monthColumn chartCalendar[Month], [Completions], Course[Course Type]
Learning hours by delivery modeDonut chartCourse[Delivery Mode], [Learning Hours]
Overdue trainingTableAssignments[Employee ID], Department[Department], Course[Course], Assignments[Due Date], [Days Overdue]

Questions this dashboard answers

Each one is answered by a visual on the page, from the sample model's own tables and measures.

About this dashboard layout

Training reports serve two masters: compliance, which needs every mandatory course done on time, and development, which wants people learning. The gauge on the left of the top row shows mandatory-training compliance against a 95% target; the cards beside it are overdue assignments, completions, learning hours per employee and the average assessment score.

Compliance is completed mandatory assignments over those completed or overdue, so courses not yet due neither help nor hurt. The Calendar is related to the completion date, which makes completions by month correct by default; the overdue measures remove the date filter, because an overdue assignment has no completion date.

Compliance by department is sorted lowest first for the managers' follow-up, and completions by month are stacked by course type so a spike in mandatory courses before an audit stands out. The donut splits learning hours between e-learning, classroom and virtual classroom.

The overdue table lists each overdue assignment with an anonymous employee ID, department, course, due date and days overdue. The sample covers 480 assignments across 12 courses at a fictional 450-person company.

Visuals on the page

Positions are Power BI page pixels. Enter them in Format → General → Properties → Size and position, or use the PBIP download where they are already set.

Visual positions in the Learning & Training Compliance template
VisualTypeXYWidthHeight
DepartmentSlicer9202416040
Course typeSlicer10962416040
Mandatory complianceGauge11212020080
Overdue assignmentsCard36012014480
CompletionsCard59212014480
Learning hours per employeeCard82412014480
Avg assessment scoreCard105612014480
Compliance by departmentBar chart112248432192
Completions by monthColumn chart592248648192
Learning hours by delivery modeDonut chart112488432192
Overdue trainingTable592488648192

Custom visuals for this layout

Built-in Power BI visuals cover most slots above. These slots also suit a custom visual; each page covers the data shape, DAX and a prompt to generate it as a .pbiviz.

Already have a report?

Brand Makeover tries Learning & Training Compliance first on every page of your Power BI project (.pbip zip) where it fits: the page's visuals have to go into its 9 data slots without overlaps. Pages it can't seat get another catalog layout or a brand grid. Queries, filters and bookmarks are left as they are. Free, in your browser.

Opens with the Analyst / Dense preset, because the Executive preset doesn't use this layout (9 data slots; this preset uses templates with at most 7).

Restyle my report into this

Swap a slot for a custom visual

Pick any slot and VizForge AI writes a custom visual (.pbiviz, with TypeScript source) sized to it, in this template's colours and shaped for the fields it is bound to.

Generate one that fits this layout.

Gauge · 200×80 px · bound to [Mandatory Compliance %], [Compliance Target]

1, 2 or 5 credits depending on the brief · 5 free on signup. Sign in or create a free account on the next screen; the brief is saved for 30 minutes.

Brief sent to the generator (you can edit it there)

A Power BI gauge visual titled "Mandatory compliance". Purpose: Against the 95% target. It sits in a 200×80 px slot on a designed report page. Match the report's brand: data colours #0F766E, #4F46E5, #B45309, #BE185D, #0369A1, #65730F; background #FFFFFF; text #1E293B; font Segoe UI. Transparent visual background so the page design shows through; no visual border. In the sample model it is bound to [Mandatory Compliance %], [Compliance Target]; keep the same data roles so the fields drop straight in.

Not sure what to build? Browse the visual catalog or open the template in the design studio and hand off any slot from there. Or start in the AI generator with a blank brief.

Colours and theme

Arctic Teal

Cool light Power BI theme with a deep teal lead, slate text and ice-grey page; AA-checked data colours for IT, healthcare and service reports.

See the Arctic Teal palette and contrast checks →

Use the background in an existing report

Prefer to keep your own report? Apply the design to it instead of opening the PBIP.

  1. 1

    Download the background

    Take the 1920×1080 PNG for a new page in a Fluent 2 report (the default size for new pages), or the 2× PNG (2560×1440) for sharp text on a 1280×720 Classic page. Power BI scales the image to the canvas.

  2. 2

    Set the canvas background

    Format page → Canvas background → Browse. Set Image fit to Fill and transparency to 0%.

  3. 3

    Import the theme

    Design ribbon → Import theme (in the Power BI service: View → Theme pane), then pick the downloaded JSON. Data colours and fonts now match the design. Older Desktop builds: View → Themes → Browse for themes.

  4. 4

    Place your visuals

    Size each visual to the positions above with background and border off, or open the PBIP project where they are already placed.

Questions about this template

Does the Learning & Training Compliance template come with sample data?

Yes. The “PBIP with sample data” download contains a semantic model with 4 tables and 8 DAX measures, and every visual on the page is already bound to it. The sample: Training records at a fictional 450-person company from January to October 2026: 480 course assignments across six mandatory compliance courses and six development courses, with due dates, completion dates, assessment scores and days overdue at 31 Oct 2026; department headcount gives learning hours per employee. The data is written into each table's Power Query step, so there is no data source or sign-in.

Is it a .pbix file?

It is a Power BI project (PBIP): a folder of text files that Power BI Desktop opens like a .pbix. Open the .pbip file, select Refresh once to load the sample rows, then use File → Save as if you want a single .pbix.

What visuals are in the Learning & Training Compliance template?

The page has 11 visual areas: 2 slicers, 1 gauge, 4 cards, 1 bar chart, 1 column chart, 1 donut chart, 1 table. Their exact positions are listed on this page so you can match them in Power BI's Format → General → Properties panel, or skip that step by downloading the PBIP project.

Which theme does the Learning & Training Compliance template use?

It ships with the Arctic Teal theme (light tone). Download the theme JSON here, or open the template in the design studio and switch to any other theme or your own brand colours.

Is there a dark version of the Learning & Training Compliance template?

Yes. Switch the preview to Dark and every download (background, theme JSON and PBIP) comes in that version. The layout is identical; the page, card and text colours are re-solved for a dark page, and the accent, status and data colours keep their hues but are adjusted until text meets WCAG AA (4.5:1) and chart colours reach 3:1 against the cards.

How do I use the background image in Power BI Desktop?

Select the page, open Format page → Canvas background, choose Browse and pick the PNG, then set Image fit to Fill and transparency to 0%. Give your visuals a transparent background and no border so the designed panels show through.

Can I open the PBIP project in Power BI Desktop?

Yes. PBIR is the default report format in Power BI Desktop since September 2026, and the download is a PBIP project: unzip it and open the .pbip file, select Refresh once and the sample data loads into visuals that are already bound (the empty PBIP leaves the containers unbound for your own data). Microsoft still lists projects and TMDL as preview features (as of Nov 2026), so if Desktop won't open it, enable them under File → Options and settings → Options → Preview features.

Dashboard guides that use these visuals

Guides to the same dashboard job: which custom visuals it needs, the DAX behind them and prompts to generate them.

KPI cards for this layout

Headline numbers drawn by one DAX SVG measure each, for the Card visual or a table row.

Want the headline numbers to look like cards rather than plain values? Browse the KPI card gallery or build your own in the SVG measure builder.

Related templates

Keep exploring

Dashboard templates

61 hand-designed Power BI page layouts by department.

Power BI themes

80 contrast-checked theme JSON files, light and dark.

Background images

Page backgrounds at 1280×720 and 1920×1080 with visual positions.

Power BI icons

3,034 icons in 40 categories as SVG, PNG, DAX or theme icon JSON.

Make the Learning & Training Compliance template yours

Swap in your brand colours and logo, move panels, add icons and generate missing visuals with AI, then export the background, theme JSON and PBIP project.

Open in the design studio →Browse templates

The design studio for Power BI. Free, in your browser, no sign-up.