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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PhilipTreacy, 
I have tried using this measure but it's not highlight single max value instead if the line chart has data points of  4.5,4.4,4.3 then all the data points are highlighted instead of one

 

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    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