Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

min and max data point highlights

Hi,  I was trying to highlight only min and max data labels in the line chart.  I have used date column which is of this format 01-01-2024 ,start time  10.00.00 AM , End time  1...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi Anonymous 

     

    If I have 4.3, 4.4 and 4.5 (the max) in my data set, 4.5 is highlighted as the max value, please check my example PBIX file.  So for your numbers it should also work.

     

     

     

    If the same isn't happening for you then either your data is somehow diferent or more likely the DAX measure isn't working as expected.  Either way I'd need to see the data you are using to figure out why.

     

    Can you post your data here, or better still, link to your PBIX file?

     

    Regards

     

    Phil

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.