Draw not summarized line in column chart from another table

[Anonymous]

Hi,

I have two queries:

1. Actuals (new premiums on daily level, grouped in a matrix to monthly level)
2. Targets (target premiums on monthly level)

I want to display the target line for each month in the stacked column chart, as depicted in the screenshot below. At the moment the line is flat but the line should indicate the target for each month. Unfortunately I do not have a "do not summary" option for the line values. Also changing the default summarization uption to don't summarize for the target values does snot help.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Take a try of below visual:

if you'd like to add a flat line, use a standard column chart and use the "Analytics" pane to add a constant line: