How to create line value for each column series in line and clustered column chart

[belurrashmi]

Hi,

I am using Power BI desktop and would like to show the line value for each column series ( severity ). I created a Quick measure for totals and used that for creating line values.

My table has column to calculate whether each defect is over target or under target depending on the cycletime.

[v-yulgu-msft · Accepted solution]

Hi @belurrashmi,

From below image, we can see the legend in a line chart can divide a line into several series based on legend items. However, the legend in a combination chart seems doesn't work, because it only applies to column bars in a combination chart.

To work around that, you should create multiple measures to generate multiple lines based on different legend items.

Count over High =
CALCULATE (
    COUNT ( 'Line chart'[Target] ),
    FILTER (
        'Line chart',
        'Line chart'[Level] = "High"
            && 'Line chart'[Target] = "Over Target"
    )
)

Count over Low =
CALCULATE (
    COUNT ( 'Line chart'[Target] ),
    FILTER (
        'Line chart',
        'Line chart'[Level] = "Low"
            && 'Line chart'[Target] = "Over Target"
    )
)

Count over Medium =
CALCULATE (
    COUNT ( 'Line chart'[Target] ),
    FILTER (
        'Line chart',
        'Line chart'[Level] = "Medium"
            && 'Line chart'[Target] = "Over Target"
    )
)

Besides, you can submit a feature request on idea.

Best regards,
Yuliana Gu

[Anonymous]

Would you be able to start the line values according to the lenger. For example show the line values Count of HIGH from the column Level HIGH and similarly the line  Count of Medium originate from the column Medium. At the moment it seem to be originating from the middle of the column