Help with line and stacked chart

[kpavan999]

In the below line and stacked column chart, can we show the values with "Y" as lines?

One option that i could think of is by creating 2 variables like below and have each of that in column values and line values, but not able to create measure like this. Any thoughts pls

1. score where flag=Y

2. score where flag=N

[v-janeyg-msft · Accepted solution]

Hello, @kpavan999 

You can create meausures.

Like this:

Y = CALCULATE(MAX('Table'[score]),'Table'[Flag]="Y")

N = CALCULATE(MAX('Table'[score]),'Table'[Flag]="N")

 Then put N in column values and Y in line values.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[amitchandak]

@kpavan999 , You need to create a measure score with flag Y and Flag with N and then use them as measures in stacked line or clustered line visual and show the measure with flag Y on line