min and max data point highlights

Hi Anonymous 

 

Maybe you can try this alternative workaround:

First of all, I create a set of sample:

Then add a Line and clustered column chart in report view:

Next, add a measure:

MEASURE =
VAR _maxValue =
    CALCULATE ( MAX ( 'Table'[Total_Apparent_Power] ), ALLSELECTED ( 'Table' ) )
VAR _minValue =
    CALCULATE ( MIN ( 'Table'[Total_Apparent_Power] ), ALLSELECTED ( 'Table' ) )
RETURN
    IF (
        MAX ( 'Table'[Total_Apparent_Power] ) = _maxValue,
        _maxValue,
        IF ( MAX ( 'Table'[Total_Apparent_Power] ) = _minValue, _minValue )
    )

And put it in the Column y-axis field, the result is as follow:

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous 

 

Download PBIX file with example below

 

How do you wish to highlight the min and max points?  You could chnage the color of the label (value) with this measure and using it as the conditional formatting rule for the label color

 

 

 

Max_TAP_CF = 

VAR _max = CALCULATE(MAX('DataTable'[Total_Apparent_Power]), FILTER(ALL('DataTable'), SELECTEDVALUE('DataTable'[Date]) = 'DataTable'[Date]))

VAR _min = CALCULATE(MIN('DataTable'[Total_Apparent_Power]), FILTER(ALL('DataTable'), SELECTEDVALUE('DataTable'[Date]) = 'DataTable'[Date]))

VAR _point = SELECTEDVALUE('DataTable'[Total_Apparent_Power])

RETURN

IF(_point = _max, "orange", IF( _point = _min, "green", "white"))

 

 

 

which gives this

 

 

As I've chosen to color all other labels/values white they do not appear.  You can show these of course if you wish be leaving them the default black color.

 

Regards

 

Phil