Skip to main content
IT

Power BI Line and Column Combo Chart: Actuals and Targets Tutorial

Build a Power BI combo chart with a small practice dataset, clear measures and checks that catch misleading axes and repeated targets.

AB
ABC Trainings Team
November 19, 2026 — 10 min read

Power BI Line and Column Combo Chart: Actuals and Targets Tutorial (Updated November 2026)

A Power BI line and column combo chart puts two related measures on one shared category axis: use columns for monthly actual sales and a line for the target. Deloitte and nasscom projected Indian AI talent demand above 1.25 million by 2027 in their August 2024 report; learning to explain and verify data is a useful foundation for that wider digital-skills shift. In this tutorial, you’ll build a small report, check every total and explain what the chart actually says.

TL;DR
  • Use Line and clustered column chart for one actual measure and one target measure.
  • Keep actuals and targets at the same reporting level before plotting them.
  • Use a common scale for two currency measures; a percentage needs a clearly labelled separate scale.
  • Verify monthly values and totals in a table before styling the chart.

What does a Power BI line and column combo chart show?

A combo chart shows columns and a line against the same categories, making it useful for reading an actual value beside a target or related trend. Choose it when the relationship between the measures is the main question, such as whether each month met its sales plan.

For this exercise, the columns represent actual sales and the line represents the target in the same currency. A reader should be able to identify the weakest month without opening a separate spreadsheet. A good title is “Monthly sales and target — training dataset”; “Performance dashboard” is too vague to explain the chart.

Power BI provides line-and-clustered-column and line-and-stacked-column options. Start with the clustered option for this simple example. The stacked option becomes relevant when the column itself needs a meaningful composition, such as sales split by category. Microsoft’s combo-chart reference describes the supported visual and axis controls. Microsoft’s column-chart guide explains the category and value roles used in this exercise.

Power BI Line and Column Combo Chart: Actuals and Targets Tutorial
Real student workshop at ABC Trainings

What data should you use for an actual-and-target practice chart?

Use a small table with one row per month and separate numeric columns for actual sales and target. The four-row dataset below is a practice example, so you can calculate the expected answers before building the visual.

Create an Excel table named MonthlySales with MonthStart, ActualSales and SalesTarget. Enter the dates as real dates, such as 1 January 2026, rather than mixing text formats. The amounts in the table are invented for the exercise and represent rupees. Keep currency symbols in the display formatting rather than typing them into cells as text.

Our actual total is ₹4,50,000 and the target total is ₹4,70,000. February exceeds target; January, March and April fall short. Write those four facts beside your working file. If the finished chart tells a different story, inspect the model or formatting before polishing colours.

For a first exercise, use one flat table. When the source becomes transactional, actual sales and targets may have different granularity. Microsoft’s modelling guidance explains how facts, dimensions and measures support reliable summarisation.

Practice data: monthly sales and target in rupees
MonthStartActualSalesSalesTargetVariance
2026-01-0190,0001,00,000−10,000
2026-02-011,20,0001,10,000+10,000
2026-03-011,05,0001,20,000−15,000
2026-04-011,35,0001,40,000−5,000

Which DAX measures do you need for actuals, targets and achievement?

Create explicit measures for actual sales, target, variance and achievement so the same definitions can be reused in the table and chart. Achievement should divide the total actual by the total target in the current filter context.

Use these measures with the practice table:

Actual = SUM(MonthlySales[ActualSales])
Target = SUM(MonthlySales[SalesTarget])
Variance = [Actual] - [Target]
Achievement = DIVIDE([Actual], [Target])

Format Actual, Target and Variance as currency. Format Achievement as a percentage with one decimal place. The whole-dataset result is approximately 95.7% because ₹4,50,000 divided by ₹4,70,000 is about 0.9574. The variance is minus ₹20,000.

SUM adds a numeric column, while DIVIDE handles a zero denominator by returning blank unless you specify an alternative. Keeping an undefined achievement blank is often more informative than displaying an invented percentage. Decide what a zero target means in your reporting context before choosing another result.

Power BI Line and Column Combo Chart: Actuals and Targets Tutorial
Real student workshop at ABC Trainings

How do you place the measures in the combo chart?

Choose the line-and-clustered-column visual, put MonthStart on its X-axis, Actual in the column values and Target in the line values. Check the field wells in your installed Power BI version, because their labels and layout can change.

Use the month-start date itself for this exercise rather than an automatic year-quarter hierarchy. Set the visual to ascending chronological order. Add readable labels and a concise title explaining that both measures are in rupees. Review the four monthly pairs against the source table: January 90,000 and 100,000; February 120,000 and 110,000; March 105,000 and 120,000; April 135,000 and 140,000.

April is ₹5,000 below its target, even though it has the highest actual sales in the dataset. February is the only month above target. This is exactly why the two measures belong together: the largest sales month is not automatically the strongest month against plan.

Should the line and columns use one Y-axis or two?

Use a common numeric scale when the columns and line both show rupees, so a higher mark means a higher amount. Use a secondary axis only when a different unit or scale makes that choice useful and label both sides clearly.

If you replace Target with Achievement, the line now represents a percentage while the columns still represent rupees. Label the axes “Actual sales (₹)” and “Achievement (%)”. A 100% achievement line and a ₹1,00,000 column do not have equal meaning simply because they happen to sit at the same height.

For the actual-and-target exercise, verify that both currency series share the same minimum and maximum rather than trusting the appearance. In Power BI’s formatting pane, inspect the secondary-axis setting and the ranges. Microsoft documents the controls for synchronising the scales in its combo-chart guide. Keep a small validation table next to the chart while you work. Use the axis formatting reference when checking titles, units and ranges in your report.

How do you keep months in the right order?

Sort months using a date or a numeric period key, so January, February and March follow time order. A text label alone can sort alphabetically, which makes a trend difficult to read.

For a single-year dataset, a MonthName column can be sorted by MonthNumber. For multiple years, prefer MonthStart or a year-month label with a matching key such as 202601. Sorting January from two years by month number alone does not create a continuous two-year timeline.

Microsoft’s Sort by Column guide requires the displayed value and sort field to have compatible granularity. In your practice report, add a second year only after the four original months are correct. Then check that December 2026 is followed by January 2027 rather than combining both Januaries.

Why does the target repeat or the achievement percentage look wrong?

Repeated targets usually indicate that the target’s level of detail or filtering does not match the actuals. A misleading achievement total often comes from averaging row percentages instead of dividing the relevant actual total by the relevant target total.

Imagine that you replace January’s single row with ten invoice rows and copy the ₹1,00,000 monthly target onto every invoice. Summing that column produces a ₹10,00,000 target, even though the business target never changed. The chart is doing the requested aggregation; the dataset is representing the target at the wrong level.

Keep the target once at its intended month or month-and-branch grain, then design shared dimensions so both facts receive the intended filters. Do not fix a repeated number by casually switching SUM to MAX: that might hide the problem for one month and fail for a total spanning several months.

For percentages, recompute the total from the numerator and denominator. A simple average gives equal weight to each row, which may differ from the question the business wants answered.

How can you validate the report before sharing it?

Validate the source totals, monthly values, filter behaviour and axis units before sharing the chart. A correct report should give the same answer in a table, a card and the visual when each uses the same filters.

Use this review sequence:

  1. Display MonthStart, Actual, Target, Variance and Achievement in a table visual.
  2. Check the four source rows and the ₹4,50,000 actual total.
  3. Filter February and confirm ₹1,20,000 actual, ₹1,10,000 target and about 109.1% achievement.
  4. Clear the filter and confirm the overall achievement returns to about 95.7%.
  5. Try a zero target in a separate copy and explain why the achievement becomes blank.
  6. Ask another person to state the units and identify the only above-target month.

Save the expected answers with the report. After a refresh or a modelling change, rerun these checks. A chart that still looks familiar can carry different numbers when a relationship, filter or source row changes.

How do you turn this exercise into a useful Power BI portfolio example?

A useful portfolio example includes the dataset, measure definitions, a validation sheet and a short explanation of the decision the chart supports. Show how you checked the result and handled one deliberate mistake.

Submit a clean report page with the combo chart, a validation table and a note defining actuals and targets. Add a second page showing the repeated-target problem and your corrected model. In an interview, explain why the ratio of totals is appropriate, why the axes share a scale and how the report behaves when the date filter changes.

Here’s the thing: demonstrating a small report accurately is more convincing than presenting ten visuals you cannot explain. Build the four-month version yourself, then extend it with a branch dimension once you can predict the filtered totals.

Use the ABC course catalogue to find the current Power BI programme, the fee enquiry for a written quotation and the centre directory for delivery guidance. Bring this exercise to a demo and ask how trainers review modelling and measure choices. Call 7039169629.

For any government training scheme, verify current eligibility and approval through the official process before including assistance in your course budget. Ask ABC for the exact course fee and included learning support.

Get the IT Brochure + Fees + Batch Dates on WhatsApp

Free 1:1 counselling. Placement track record. CMYKPY/PMKVY eligibility check.

💬 Get Brochure on WhatsApp📞 Call 7039169629

About the author: Mohd. Rafique Pasha, Data Science & AI Trainer, ABC Trainings.

Visit Our Centers

  • Wagholi (Pune): 1st Floor, Laxmi Datta Arcade, Pune-Ahilyanagar Highway. Call 7039169629
  • Hadapsar (Pune): 1st Floor, Shree Tower, opp. Vaibhav Theater, Magarpatta. Call 7039169629
  • Cidco (Chh. Sambhajinagar): Kalpana Plaza, opp. Eiffel Tower, N-1 Cidco. Call 7039169629
  • Osmanpura (Chh. Sambhajinagar): S.S.C Board to Peer Bazar Road, near Jama Masjid. Call 7039169629
  • Sangli: Shubham Emphoria, 1st Floor, Above US Polo Assn., Sangli-Miraj Rd, Vishrambag. Weekend batches available. Call 7039169629

💬 WhatsApp 7774002496

FAQs

Which visual combines a line and columns in Power BI?

Choose Line and clustered column chart for a simple actual-and-target example. Assign the month to the X-axis, actuals to column values and targets to line values. Use the stacked variant when the column also needs a meaningful category breakdown.

Why should actual sales and sales target use the same axis scale?

Both measures have the same unit, so a common scale makes their heights directly comparable. Independent currency scales can make a lower value look higher. Inspect the ranges and label the units before sharing the visual.

Why does the total achievement differ from the average of monthly percentages?

Overall achievement is total actual divided by total target. Averaging monthly percentages gives each month equal weight even when its target differs. For this practice dataset, the ratio of totals is approximately 95.7%.

Is guided Power BI training better than self-study for a beginner?

Guided training helps when you need feedback on relationships, measures and report checks; self-study suits repeated practice once you can validate your own results. ABC offers a free demo and publishes course details and placement-support scope, so ask the trainer to review this exercise before choosing a programme.

Free counselling

Talk to an ABC Trainings counsellor

Leave your details and our team will call you about the course, fees and the next batch at your nearest centre in Pune, Chhatrapati Sambhajinagar, Sangli or online.

Prefer to talk now? Call +91 70391 69629 or WhatsApp us.

A

ABC Trainings Editorial Team

Course and career information from ABC Trainings. Exact trainer, batch, timetable, delivery mode and complete written fee should be confirmed before enrolment.

Founder & public accountability →