Forum Discussion
Help with splitting capacity data per month
Dandel you need to create two extra dimension tables for the better design, a table for resource type and a date table, link these two tables on a respective column with these existing tables, these new dimension tables will have have unique values so it will be on to many relationship.
once this is all done, in your visual, use column from dimension on x-axis and legend and values from your existing tables and everything will work out.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡
Super UserDandel you need to create two extra dimension tables for the better design, a table for resource type and a date table, link these two tables on a respective column with these existing tables, these new dimension tables will have have unique values so it will be on to many relationship.
once this is all done, in your visual, use column from dimension on x-axis and legend and values from your existing tables and everything will work out.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡