highlight highest and lowest value of a KPI in line diagram

[Zeta]

Hi,

I would like to highlight the highest and lowest value point of a line like the sparkline mini chart in an table chart.

Does anyone have a solution?

Thx

[VBD]

Hello, 

You have this options when you select "Colors" :

Regards,

[Zeta]

Thanks, but that is the option in the table chart. I would like to assign a color to the highest and lowest points in a line chart, similar to the sparkline.

How can I do this in the line chart?

[VBD]

Ok sorry,

I think the best way to do that it's with a reference line, one for the max with an expression like.

=max(total aggr(Sum(Expression1),Year))

But you have a line.

An other option is to create,  an other mesure, in your master item, like 

if(max(total aggr(Sum(Expression1),Year))=Sum(Expression1),max(total aggr(Sum(Expression1),Year))

you define a color and you use this measure in your line chart : 

and you do the same thing for the minimum, but this option will degrade the performance.

Regards

[MatheusC · Accepted solution]

It would be easier if you gave some sample data.
Assuming you have a measure sum(sales) and dimension X

Then you could enter the following expression in the Color and Legend tab:

pick(match(
Sum(Sales),
max(total aggr(sum(Sales),[DimensionX])),
min(total aggr(sum(Sales),[DimensionX])))+1,blue(),LightGreen(),lightred())



-Regards, Matheus