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.
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.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
