Consilium
A letter from Consilium

Power BI Custom Visuals

The finance pack,
in view.

Profit and loss, financial position and the movements between the numbers. Three custom visuals for Power BI, ready to download.

Choose your visualExplore the example report

Direct .pbiviz downloads · MIT licensed packages

01 / Power BIv0.17.0

Profit & Loss

1:14 · Silent, with words on screen · Sample data
Read the transcript
  1. 0:00 Title: Power BI custom visual / Profit & Loss / Read the statement and its variances together.
  2. 0:03 01 Every comparison, with its variance, in one statement.
  3. 0:10 02 Open a group. Its subtotal stays the same.
  4. 0:17 03 Across zero, or against zero, a percentage reads n/m.
  5. 0:24 04 Press Margin on a line to add its margin to the statement.
  6. 0:32 05 Fold the group, then chart a column from its heading.
  7. 0:42 06 The gear sets the scale and hides controls for the board.
  8. 0:50 Steps: Get started / Import once.
  9. 0:50 01 Download: The free .pbiviz file.
  10. 0:50 02 Import: Import a visual from a file.
  11. 0:51 03 Map your fields: Lines, Actual in Values, each comparison in its own well, Line order.
  12. 1:08 End card: Profit & Loss for Power BI / tryconsilium.com/power-bi-visuals / Free download · MIT licence · Example .pbix to explore
Transcript as a text file

A Power BI profit and loss statement with hierarchy, scenario comparisons, calculated lines and in-column charts.

.pbiviz · 300 KB

Download Profit & LossFeatures and field guide
02 / Power BIv0.1.0

Balance Sheet

1:06 · Silent, with words on screen · Sample data
Read the transcript
  1. 0:00 Title: Power BI custom visual / Balance Sheet / Assets beside liabilities and equity, with a balance proof.
  2. 0:03 01 Two sides, each with its own total.
  3. 0:09 02 Variances take each line's direction. Neutral prints in ink.
  4. 0:17 03 The balance proof checks the two sides as printed.
  5. 0:25 04 Tag lines sets every line's direction in one window.
  6. 0:36 05 Show variances as amounts or as percentages.
  7. 0:43 Steps: Get started / Import once.
  8. 0:44 01 Download: The free .pbiviz file.
  9. 0:44 02 Import: Import a visual from a file.
  10. 0:44 03 Map your fields: Lines, the balance, each comparison, Side and Line order.
  11. 1:00 End card: Balance Sheet for Power BI / tryconsilium.com/power-bi-visuals / Free download · MIT licence · Example .pbix to explore
Transcript as a text file

A two-sided Power BI balance sheet visual with scenario comparisons, financial direction and a balance proof.

.pbiviz · 267 KB

Download Balance SheetFeatures and field guide
03 / Power BIv0.5.0

Variance Bridge

1:23 · Silent, with words on screen · Sample data
Read the transcript
  1. 0:00 Title: Power BI custom visual / Variance Bridge / From plan to actual, one line at a time.
  2. 0:03 01 From the plan, outlined, to Actual, solid.
  3. 0:09 02 Click a bar to open it. The walk still ends at Actual.
  4. 0:17 03 Switch the comparison on the visual: last year, then back.
  5. 0:28 04 Move the total to a line with lines beneath it.
  6. 0:36 05 Expand all opens every line beneath the total.
  7. 0:43 06 Bracket a run of lines as a named subtotal.
  8. 0:54 07 Group small lines as Others, from the Format pane.
  9. 1:02 Steps: Get started / Import once.
  10. 1:02 01 Download: The free .pbiviz file.
  11. 1:02 02 Import: Import a visual from a file.
  12. 1:03 03 Map your fields: Lines, Actual and up to three comparisons.
  13. 1:17 End card: Variance Bridge for Power BI / tryconsilium.com/power-bi-visuals / Free download · MIT licence · Example .pbix to explore
Transcript as a text file

A Power BI waterfall and variance bridge visual for explaining movements between financial scenarios.

.pbiviz · 249 KB

Download Variance BridgeFeatures and field guide

The working example

Start with the finance pack.

Download the example Power BI report, open it in Power BI Desktop and inspect how the visuals are set up. Use the field mappings and formatting as a guide for your own report.

The .pbix file is a report to open. The .pbiviz files above are visuals to import into a report. No Consilium account is needed.

Download example .pbix

1.8 MB · Power BI Desktop

Direct report download
File checksum

SHA-256

8c9df3287544fc6a473403906917dbb0bcd6eaa2046acf891de0b2c3a84dc3d4

Getting started

Import once. Build your report.

  1. Download a visual

    Save its .pbiviz file. Keep that file format; it is the Power BI visual installer.

  2. Import it in Power BI Desktop

    Open your report. In the Visualizations pane, choose the three-dot menu, then Import a visual from a file. Select the .pbiviz file.

  3. Add it and map your fields

    Select the new visual in the gallery. Bind your measures and hierarchy using the guide on its product page, or inspect the example report first.

These are uncertified custom visuals. Your organisation may restrict their use. Check your Power BI policy before importing. Native PDF, PowerPoint and subscription output has restrictions for uncertified visuals; check your intended export workflow.

Microsoft guidance, checked 3 October 2026: importing a visual · organisational controls · certification and export support.

Updating a visual? Save, close and reopen the report after importing the replacement. Send feedback if you encounter a problem.

Still in development

13-Week Cash Flow

A view of cash timing for the finance pack. No public download yet.

View development status ↗

Micro Tools

Work through a calculation.

Analyse a budget variance, build an EBITDA bridge or explore working capital in your browser.

Explore Micro Tools ↗
Feedback

Save this analysis

We will store the name and this tool’s supported calculation inputs, assumptions, labels, currency and number format, plus its identifier, save dates and your account ID. Outputs are recalculated when you open it.

Chart export styling, materiality filters, monthly review datasets and connected supporting analyses are not included in account saves.

No source workbook or chart file is uploaded. Your inputs stay in the browser until you sign in and confirm saving. A temporary draft stays in this tab for up to 30 minutes while you sign in.

Saved inputs are stored on Cloudflare in Western Europe until you delete them or your account. Deleted data may remain in restricted, encrypted backups in Asia-Pacific until their 30-day expiry. A separate encrypted recovery log keeps record IDs, protected email fingerprints and deletion or unsubscribe times for 35 days so a restore does not bring deleted data back. It contains no financial inputs. Expiry runs automatically and may not remove records at the exact deadline.