Caluculate percentage of a column based on a slider

[GaryGreer]

Hi everyone,

New to Power BI, just finding my way. I have a column in my data that has times in seconds - it's for how long it takes to respond to an alarm. We have KPIs around this - for us it is currently 600 seconds. What I'm trying to do is:

Using a slicer / slider, allow users to see what percentage of calls were below the value set by the slider, using only the filtered data. This is to allow users to see what dropping the KPI down would look like. For bonus points, a graph showing the data points below the filter in 15 second increments would also illustrate the remaining data points. 

Thanks for any help.

[amitchandak]

@GaryGreer ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[GaryGreer]

Certainly can

the three calculated columns are what I'm working with - the 'duration in seconds' column is the one in question. It holds a calculated number that is extracted from the call duration column, and returns a whole number that is the number of seconds for that call.

Hope that helps!

[v-rzhou-msft]

Hi @GaryGreer ,

It seems that the calculated columns in your screenshot all return blank.

Can you share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

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

[GaryGreer]

Hi,

thanks so much for your help - I'm new to BE and just starting to figure out some of the underlying concepts. I've attached a spreadsheet with the data in it - the 'room' column has been changed for privacy. 

Call Location	Level	Room	Asset Name	Call Type	Call Duration	Time Converted	Duration in seconds	Hour of the day of call
SAMBELL LODGE	LEVEL 1	RM 1-01	null	HELP	0:00:10	0:00:10	10	00
SAMBELL LODGE	GROUND DOORS	RM 1-02	null	DOOR	0:00:18	0:00:18	18	00
SAMBELL LODGE	GROUND DOORS	RM 1-03	null	DOOR	0:00:12	0:00:12	12	00
SAMBELL LODGE	LEVEL 1	RM 1-04	null	HELP	0:00:04	0:00:04	4	00
SAMBELL LODGE	LEVEL 1	RM 1-05	null	HELP	0:00:03	0:00:03	3	00
SAMBELL LODGE	LEVEL 1	RM 1-06	null	HELP	0:00:06	0:00:06	6	00
SAMBELL LODGE	LEVEL 1	RM 1-07	null	HELP	0:00:17	0:00:17	17	00
SAMBELL LODGE	GROUND DOORS	RM 1-08	null	DOOR	0:00:13	0:00:13	13	00
SAMBELL LODGE	GROUND DOORS	RM 1-09	null	DOOR	0:00:20	0:00:20	20	00
SAMBELL LODGE	GROUND DOORS	RM 1-10	null	DOOR	0:00:16	0:00:16	16	00
SAMBELL LODGE	GROUND DOORS	RM 1-11	null	DOOR	0:00:12	0:00:12	12	00

With the display of the data, This is a rough idea of what I need:

One of our KPIs is how many calls are completed in a set time. This needs to be calculated based on the data that is filtered by the date and type slicers. Once I have the data, we then need to use another slider (at the bottom) to allow the user to do some 'what if' analysis of what percentage of calls meet a particular KPI. Aim is to encourage users to think about making the KPI tighter to help produce better data and care.

Hope that helps.