Showing only MIN/MAX Datalables in Linechart

[Janica123]

Hi all, 

I have a measure that looks like this:
Value = 

CALCULATE(

    SUMX(Table1, Table1[Col1] /8), FILTER(Table1, Table1[Col2] = "XY"))

I visualize this measure on a linechart with month names as x-Axis: 

I only want to show the datalables for the MAX and MIN Value in the chart. In this case the values 1.601,09 and 1.256,41.

Is there a way I can do this?
Thanks in advance for your help!!

[shafiz_p · Accepted solution]

Hi @Janica123  To show only max and min create 2 separate measure for maximum and minimun as given below.

Max_Revenue_Month =

VAR getMaxValue = CALCULATE(MAXX(ALL('Calendar'[Name of Month]), [Revenue]), ALL('Calendar'))

RETURN

IF([Revenue]=getMaxValue, getMaxValue, BLANK())

and 

Min_Revenue_Month =

VAR getMinValue = CALCULATE(MINX(ALL('Calendar'[Name of Month]), [Revenue]), ALL('Calendar'))

RETURN

IF([Revenue]= getMinValue, getMinValue, BLANK())

Place this two measure in y axis along with main meausre. see the image below:

Now go to data label format option. Off the data labels for main measure, for my case revenue. see the image below:

Hope this helps!!

If this solved your problem, please mark it as a solution!!

[rajendraongole1]

Hi @Janica123 -Unfortunately, Power BI does not directly support conditional formatting for data labels to show high values and low values which is a out-of-the-box.

Hope this helps.