Forum Discussion

Julier's avatar
Julier
Helper III
2 years ago

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

  • 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

  • Anonymous's avatar
    Anonymous
    Not 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 Sales

    S&OP


    Relationship


    Final output



    Best regards,
    Albert He

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

     

    • Julier's avatar
      Julier
      Helper III

      Thank you, howver i am unable to get a one to one relationship 

       

      • Anonymous's avatar
        Anonymous
        Not 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 He

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