Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Caluculate percentage of a column based on a slider

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.

4 REPLIES 4
amitchandak
Super User
Super User

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

Anonymous
Not applicable

Certainly can

GaryGreer_0-1685500754438.png

 

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!

Hi @Anonymous ,

 

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.

 

Anonymous
Not applicable

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 LocationLevelRoomAsset NameCall TypeCall DurationTime ConvertedDuration in secondsHour of the day of call
SAMBELL LODGELEVEL 1RM 1-01nullHELP0:00:100:00:101000
SAMBELL LODGEGROUND DOORSRM 1-02nullDOOR0:00:180:00:181800
SAMBELL LODGEGROUND DOORSRM 1-03nullDOOR0:00:120:00:121200
SAMBELL LODGELEVEL 1RM 1-04nullHELP0:00:040:00:04400
SAMBELL LODGELEVEL 1RM 1-05nullHELP0:00:030:00:03300
SAMBELL LODGELEVEL 1RM 1-06nullHELP0:00:060:00:06600
SAMBELL LODGELEVEL 1RM 1-07nullHELP0:00:170:00:171700
SAMBELL LODGEGROUND DOORSRM 1-08nullDOOR0:00:130:00:131300
SAMBELL LODGEGROUND DOORSRM 1-09nullDOOR0:00:200:00:202000
SAMBELL LODGEGROUND DOORSRM 1-10nullDOOR0:00:160:00:161600
SAMBELL LODGEGROUND DOORSRM 1-11nullDOOR0:00:120:00:121200
         

 

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.

GaryGreer_0-1685584426933.png

Hope that helps.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.