Add YTD Column in stacked column chart

Hi Gazsim44 ,

Please try this:

1. Enter data to create a Columns table like below and then sort "Columns" column by "Order" column.

Note: no relationship between this new table and your data table.

2. Create measures like so:

Late Measure =
VAR Columns_ =
    SELECTEDVALUE ( 'Columns'[Columns] )
RETURN
    SWITCH (
        Columns_,
        "YTD", CALCULATE ( [YTD], Data[Net Performance] = "MISS" ),
        CALCULATE ( [Late], Data[Quarter] = Columns_ )
    )

On Time Measure =
VAR Columns_ =
    SELECTEDVALUE ( 'Columns'[Columns] )
RETURN
    SWITCH (
        Columns_,
        "YTD", CALCULATE ( [YTD], Data[Net Performance] = "OK" ),
        CALCULATE ( [On Time], Data[Quarter] = Columns_ )
    )

3. Put 'Columns'[Columns] into "Axis" field and [Late Measure], [On Time Measure] into "Values" field to create a visual.

You can this post: Possible Analytics function: dynamic Total column in chart with USA States?

Not exactly the same, but the logic is the same.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.