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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Traceout
Frequent Visitor

Multiple parameters into one table column

Hello. I'm trying to create a dashboard that has multiple parameters for 'area workers' that can be used to calculate how long it would take to finish the jobs in a particular area. 

 

For example, If I have the SOUTH area and it has 3 jobs that take 30 minutes and I have a SOUTH WORKER parameter of 3 it would take 30 minutes to finish the jobs.

 

2023-05-23_13-40-20.png

 

I believe I can achieve this by being able to create another table that has the distinct AREAS with the 'area workers' parameter value but I'm not able to figure out how to create a column from each of the seperate parameters. 

 

expected output: 

 

AREAS

Parameter Values
SOUTH

    1

NORTH    2
etc    etc

 

any help would be appreciated. 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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