Forum Discussion

FawnShupp's avatar
FawnShupp
Regular Visitor
4 years ago
Solved

Choosing the right Visual

Hello,

 

I'm really new to Power BI and am waiting to go through the DA-100 training. In the meantime, I'm learning on the go and maintaining some reports and dashboards that previously existed. I'm struggling with choosing the correct visual for a report I'm working on. Here's a sample of the data table in BI that I'm pulling info from for the visual:

 

Machine / Work CenterProd Week Labor Labor Cap  Machine Cap  Actual Need ProdWeek WorkCenter
30043         127.50                          -    43300
70143           85.00                          -                    72.0043701
3AXIS_LG43         127.50                 340.00                  87.50433AXIS_LG
3AXIS_SM43         375.28                 935.00               226.02433AXIS_SM
4AXIS43         255.00                 340.00                  65.50434AXIS

 

Here is an example of how management would prefer to see the data. They'd like to see by Machine/Work Center, and production week, the Actual Need, Labor Cap, Machine Cap, and some calculated columns for Available Capacity, and Cumulative Capacity. Cumulative is the hotter data. I think I could lose Available Capacity since it's just measuring the specific week, without taking the past due information into account.

 

 

I just don't really know how to visualize this. They'd like to see all the machines at once, but then filter by machine if needed. I was thinking a matrix at first, but that didn't seem to lay out right, unless I set them up wrong. 

 

Any thoughts which would be best? I'm not married to the exact layout as the sample above, but something that provides a similar visual. 

 

Thanks!

Fawn Shupp

3 Replies