Conditional formatting for multiple Y-axes in bar chart/ area chart

[Yonah]

Hi,
I hope that there might be a solution after all.
I have an area diagram with two lines, and I want to mark the highest and lowest points of each line.
Is there a solution for this?

For one line I proceeded as follows, first I wrote the following measurer:

Max/MIN Abs.gross turnover Afterbuy Max =.
VAR Gross Sales = [Abs. Gross Sales Afterbuy Max]
VAR OfficeGross = [Abs. Gross Sales OfficeChairs]
VAR MaxABS =
MAXX ( ALL ( stock ), [Abs. gross sales Afterbuy Max] )
VAR MINABS =
MINX ( ALL ( stock ), [Abs. gross sales Afterbuy Max] )
VAR RESULT =
SWITCH (
TRUE ( ),
Gross sales = MaxABS, "Green",
Gross Sales = MINABS, "Red",
"Blue"
)
RETURN
RESULT

In the second step I converted the area chart into a line chart. And then applied it to the Columns for Meassuer. This was also possible without any problems.
However, as soon as there is a second Y-axis in the bar chart, it is not possible to set a conditional formatting for both.
Is there a way to achieve this?

Because as soon as I change the chart from the bar chart to the area chart, the formatting remains.
And locks like this, but of coure the red dote fore the dark blue line is wrong.

Thanks

[v-yanjiang-msft]

Hi @Yonah ,

Based on my test, in the latest version, color of marks in the area chart doesn't support conditional formatting. May I know how you did it?

Best Regards,
Community Support Team _ kalyj