Finance dashboard example: revenue and direct cost
A finance dashboard brings financial measures and their reporting periods into one review view. This synthetic example defines revenue of 345,000 and direct cost of 228,000, giving gross profit of 117,000 and gross margin of 33.91% for January–March 2026.
Updated
How can I try this finance dashboard with my CSV?
The live view opens the clearly marked synthetic sample. Choose Use my CSV or paste a CSV to replace it, then match the category, period and measure fields. Continue editing in xmetric carries the current view into the app.
Synthetic sample · January–March 2026 · illustrative currency units
Use a header row, one category column, one reporting-period column and a numeric measure. Use a numeric reporting period, YYYY-MM (for example 2026-01), or YYYY-MM-DD (for example 2026-01-31). Labels such as Q1 or Q2 are not supported; convert them to a numeric period or an explicit date before importing. Choose fields after importing. CSV limits: 32 MiB on lower-memory devices or 160 MiB on higher-memory devices, and 3.5 million source rows. Views support up to 10,000 marks per sheet. Continue editing supports up to 100,000 source rows.
Opening the synthetic sample. Your own CSV replaces it.
The live view aggregates the selected primary and comparison fields, calculates the defined comparison, and charts the primary measure by category and period. The linked sample record defines the expected values for the initial SUM settings. A ratio with a zero denominator is undefined.
What question does this dashboard example answer?
Compare monthly revenue and direct cost by department, with an explicit gross-profit definition.
Use revenue and cost views to locate a department or month worth reconciling to the ledger. The source table is a teaching example, not a financial statement: it has no cash balance, receivables, operating expenses or balance-sheet entries.
Which fields and row grain does this sample use?
Each of the six synthetic rows is one category-month summary for January–March 2026. The fields below define this example; importing a CSV does not import hidden Power BI measures or Tableau calculations.
| Field | Definition |
|---|---|
| Period | Reporting month in YYYY-MM format; all rows use the same illustrative reporting basis. Your own CSV may use numeric periods, YYYY-MM or YYYY-MM-DD; Q1/Q2 labels are not supported. |
| Department | Product or Services, the synthetic department to which revenue and direct cost belong. |
| Revenue | Recognized revenue in illustrative currency units at department-month grain. |
| Cost | Direct cost associated with that department-month revenue; excludes operating expenses, tax and financing. |
How are the worked sample metrics calculated?
The formulas below define this sample using all six rows, with no additional filters. They are independently checkable arithmetic expectations, rather than a claim of native Tableau or Power BI parity.
Download the exact synthetic sample CSV · Read the definitions and expected values (JSON)
| Metric | Formula | Defined sample value | Definition |
|---|---|---|---|
| Revenue | SUM(Revenue) | 345,000 | Add the six department-month revenue values. |
| Direct cost | SUM(Cost) | 228,000 | Add direct costs for the same six rows. |
| Gross profit | SUM(Revenue) − SUM(Cost) | 117,000 | 345,000 − 228,000; this sample excludes other expense categories. |
| Gross margin | 100 × (SUM(Revenue) − SUM(Cost)) / SUM(Revenue) | 33.91% | 117,000 / 345,000 × 100 = 33.913043…%, rounded to two decimals; undefined at zero revenue. |
Revenue is 100,000 in January, 115,000 in February and 130,000 in March. Direct cost is 66,000, 76,000 and 86,000 respectively. Product revenue totals 240,000 and Services revenue 105,000, reconciling to 345,000.
Which exact rows produce those sample numbers?
The following rows are the complete authored sample behind this page, not customer data or an industry benchmark. Use the linked CSV and JSON record to reproduce the defined totals.
Download the exact synthetic sample CSV · Read the definitions and expected values (JSON)
| Period | Department | Revenue | Cost |
|---|---|---|---|
| 2026-01 | Product | 70000 | 42000 |
| 2026-01 | Services | 30000 | 24000 |
| 2026-02 | Product | 80000 | 48000 |
| 2026-02 | Services | 35000 | 28000 |
| 2026-03 | Product | 90000 | 54000 |
| 2026-03 | Services | 40000 | 32000 |
How do I prepare and inspect my own dashboard data?
Use one consistent row grain, identify the category and reporting-period columns, and select the numeric measure whose aggregation answers your question.
- Remove precomputed total rows when your CSV also contains their underlying detail.
- Use a numeric reporting period, YYYY-MM (for example 2026-01), or YYYY-MM-DD (for example 2026-01-31). Labels such as Q1 or Q2 are not supported; convert them to a numeric period or an explicit date before importing.
- Choose Use my CSV or paste the header and rows; match the category, period and measure controls to your columns.
- Start with SUM for additive measures. AVG is a mean of input rows, not a weighted ratio.
- Compare the total, category split and period view with the source export before continuing in xmetric.
What can change the interpretation of this dashboard?
Gross profit is not net profit or cash flow. Keep the cost scope and recognition period explicit, avoid counting both monthly detail and a precomputed total row, and reconcile your selected columns to the source report before drawing a financial conclusion.
This CSV example supplies only the explicitly listed fields. A Power BI Desktop .pbix or Tableau .twbx workbook may contain additional calculations, filters and relationships; the CSV is not a replacement for those governed definitions.
Which dashboard example can I inspect next?
Choose a different example when its row grain and metric definitions better match the review you need to perform.
How do the measures in this dashboard differ?
These measures answer different questions over the same sample rows. A total, a count and a ratio have different definitions; changing the selected column does not create a new governed calculation.
| Measure | Question it answers | Formula | Defined sample value |
|---|---|---|---|
| Revenue | What revenue is recognized? | SUM(Revenue) | 345,000 |
| Gross profit | What remains after this sample's direct cost? | SUM(Revenue) − SUM(Cost) | 117,000 |
| Gross margin | What share of revenue is that gross profit? | 100 × gross profit / revenue | 33.91% |
What else do people ask?
This finance dashboard uses the explicitly defined sample fields above. The answers below clarify which measures are live, which are worked calculations, and which source files are available.
Does this finance dashboard show cash flow or net profit?
No. The sample contains revenue and direct cost only. Its gross profit excludes operating expenses, tax and financing, and its rows contain no cash receipts or payments. Those questions require additional, explicitly defined data.
Does the live finance panel calculate gross margin?
The panel calculates revenue, direct cost, their difference and gross margin from the selected fields, then charts the primary measure by department and month. With the sample's default SUM settings, gross profit is 117,000 and gross margin is 33.91%. A zero revenue denominator leaves margin undefined; changed fields need the same revenue-and-cost meaning.
Which reporting-period values can I use in my CSV?
Use a numeric reporting period, YYYY-MM (for example 2026-01), or YYYY-MM-DD (for example 2026-01-31). Labels such as Q1 or Q2 are not supported; convert them to a numeric period or an explicit date before importing.
Can I download this example as a Power BI .pbix file?
This page provides the exact synthetic CSV and its definition record. It does not provide a Power BI .pbix download. Continue in xmetric to inspect the actions available for the current workbook.
Are the sample numbers measured customer or native workbook results?
No. These are authored synthetic inputs and defined arithmetic expectations. They are neither customer results nor evidence of native Tableau or Power BI compatibility. Reconcile the live result to your own source after replacing the sample.