Choosing the right Visual

[FawnShupp]

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 Center	Prod Week Labor	Labor Cap	Machine Cap	Actual Need	ProdWeek WorkCenter
300	43	127.50	-		43300
701	43	85.00	-	72.00	43701
3AXIS_LG	43	127.50	340.00	87.50	433AXIS_LG
3AXIS_SM	43	375.28	935.00	226.02	433AXIS_SM
4AXIS	43	255.00	340.00	65.50	434AXIS

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

[v-xiaoyan-msft]

Hi @FawnShupp ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@FawnShupp adding on comments from @amitchandak , the better option is to unpivot your data and then add a sort key the way you want to see the prod week, basically, Past Due sort value will be before other weeks, and from here everything should be straight forward. Data prep in this case is key than visualization.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak · Accepted solution]

@FawnShupp , Seem like show on rows(Measure on row); option in formatting option of matrix 

week on matrix column

and no row. Ony problem is past due.

That need a hybrid table

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc