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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
manoj_0911
Post Patron
Post Patron

Dynamic Duration Selection

Hi everyone,

I'm building a Power BI report with contact center data (durations in seconds/milliseconds) including available, on queue, etc. I've created a detail table, but I need some help with customization:

Detail Table Sorting:

  • I want the detail table sorted by Date, Name, Group Name followed by duration metrics (Available, On Queue, Break, Busy, Idle).

Dynamic Duration Selection:

  • I'd like users to be able to select which duration metrics they want to see displayed in the detail table.

Duration Formatting:

  • All displayed durations should be formatted in HH:MM:SS format.

Attachment:

 

Request:

Any guidance on achieving these functionalities within Power BI would be greatly appreciated.

1 ACCEPTED SOLUTION
aduguid
Super User
Super User

You an use a field parameter to achieve this "Dynamic Duration Selection".  You can setup a slicer to reference the field parameter and then add the field value to your table then it's dynamic. You can even set one up for the columns you want to group by.

View solution in original post

1 REPLY 1
aduguid
Super User
Super User

You an use a field parameter to achieve this "Dynamic Duration Selection".  You can setup a slicer to reference the field parameter and then add the field value to your table then it's dynamic. You can even set one up for the columns you want to group by.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.