Forum Discussion
LINE AND STACKED COLUMN CHART
Im trying to create this visual, however the S&OP figure is a changing figure each month but it will only show it as a sum, it wont let me show it without summing it, the data is in 2 tables, i have been trying all different ways to show the data correctly in this kind of chart but with no luck, hope someone can help me please
5 Replies
- lbendlinSuper User
You posted this in the Power Query forum?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - AnonymousNot applicable
Hi Julier ,
If you want to display values in different tables without summing. You need to establish a relationship between the two tables.
Sample data
Monthly SalesS&OP
Relationship
Final outputBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- JulierHelper III
Thank you, howver i am unable to get a one to one relationship
- AnonymousNot applicable
Hi Julier ,
Thank you for your reply, the issue is due to the fact that you have duplicates in your data and the model is unable to create a relationship on that. You can create relationships with non-duplicated primary keys, for example you can create relationships based on event ids (non-duplicated)
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly