PowerBI to show only data that is >5 seconds in a chart

[zurimae]

Hi, I have call data that we want show only dropped calls that are greater than 5 seconds. I have a column of abandoned calls that show in seconds, but i need to weed out anything 5 seconds or less (hangups usually). How can i create a formula or have powerbi only show anything greater than 5 seconds in my chart? Thanks!

[parry2k]

@zurimae what I'm looking here? Avg Alban Time column is the one you want to filter where > 5 seconds? Are those values in seconds?

[zurimae]

So i would either need to figure out how to have this column ignore anything 5 seconds less when i continue to add data daily, or create a new column with a formula that would return any value 5 seconds or less into 0 so it wont count it. i just dont know how to do that formula.  in my original database, not power bi, the formula i used was this -but i dont know how to do that in query

[v-zhangti · Accepted solution]

Hi, @zurimae 

You can try the following methods. I have briefly simulated some data.

Create a new table.

Table 2 = 
Var Table2=SUMMARIZE('Table','Table'[Date],'Table'[Calling ID],'Table'[Calling time])
Return
FILTER('Table',[Calling time]>5)

This avoids various situations where the talk time is less than 5 seconds.

Best Regards,

Community Support Team _Charlotte

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

[zurimae]

Thank you, i created a new measure with this formula and it worked 

[v-zhangti]

Hi, @zurimae 

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards,

Community Support Team _Charlotte

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

[zurimae]

yes, the avg abandoned time column, the numbers reflect seconds. 

[parry2k]

@zurimae how your raw data looks like? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[zurimae]