Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Line Graph - Show Only Lines Below Threshold Line

Hi Everyone,   Need some advice on how to display only lines that have a value below my SLA line? I have this line graph that shows applications and their uptime % across the year. However, I want ...
Need Help
Tips and Tricks
Tutorial Requests
TomMartens's avatar
TomMartens
Super User
2 years ago

Hey Anonymous , 

 

creating a measure is the way to go.

But you do need to check if there is any value in the series that is above/below the SLA, if this is the case than the measure returns e.g. 1 for every data point in the series, instead of checking the an individual data point.

 

You can achieve this by creating a measure like so

 

measure to hide series =
if(
    countx(
        allselected(<the column from the xaxis>)
        , if( [datapoint] < [sla]
            , 1
            , blank()
        )
    ) > 1
    , 1
    , blank()
)

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Tom,

 

Thank you for answering so promptly! I tried the measure you suggested but it's still not quite right. At the moment, it is only showing one of the applications that meets the criteria. However, I expect ~8 lines to appear that fall below the threshold.

 

 

I placed these values into a chart to see the measure's values against other applications and it's only tagging the 1 application below the SLA.

Here is what the measure looks like -

hide_series =
if(
    countx(
        allselected(Dates[MonthYear])
        , if( [pct_uptime_converted] < 99.9000
            , 1
            , blank()
        )
    ) > 1
    , 1
    , blank()
)