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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Based on your description, I made simple samples and you can check the results as follows:

Original data on the left, filtered below 99.90 on the right.It can also screen data above 99.90:

For DAX:

Measure = var _T = CALCULATE(MAX('Table'[DateTime]),FILTER('Table','Table'[pct_uptime_converted]<99.90))
return IF(_T<>BLANK(),0,1)

 

Please feel free to correct me and provide more information if I have misunderstood you!

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous,

Thank you for your time and efforts in trying to help me resolve this issue. 

 

However, TomMartens  solution was closer to the solution I'm looking for, it showed the entire application's uptime for the year because the application's datapoints fall below the SLA line. However, it only showed 1 of the 8 applications that fell below the SLA line.