Forum Discussion

jaaeson's avatar
jaaeson
Frequent Visitor
5 years ago
Solved

Line and Stacked Column Chart - Totalised scheduled production hours vs a capacity line

I have a production plan table with hours required per product per line per week. I want the hours per product as stacked columns for each week and the line as a slicer (this I can do). Where I com...
Need Help
  • moizsherwani's avatar
    moizsherwani
    5 years ago

    Unfortunately, I am still not 100% sure I understand your problem but can you see if tweaking the model in the manner given will resolve the issue. Remember to use the Line and Week in any visual / tables from the Dimension (Line and Weeks) tables and not from the Fact (Production and Capacity table)

     

     

     

     

moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
5 years ago

Unfortunately, I am still not 100% sure I understand your problem but can you see if tweaking the model in the manner given will resolve the issue. Remember to use the Line and Week in any visual / tables from the Dimension (Line and Weeks) tables and not from the Fact (Production and Capacity table)

 

 

 

 

jaaeson's avatar
jaaeson
Frequent Visitor
5 years ago

Yes, I needed to use the weeks/line from the dimention table. So simple after going down a rabbit whole of DAX formulae...  Well, I've learnt a lot of new tricks and you've taught me a key fundamental. Thanks!