Forum Discussion
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 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
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
3 Replies
- amitchandakSuper User
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc - parry2kSuper User
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.⚡
- AnonymousNot applicable
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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.