Forum Discussion

HuntBA2's avatar
HuntBA2
Regular Visitor
7 years ago

Combinig 2 charts

Morning folks,   I have 2 charts that use the same formating and when run seperately work fine, but when I try to combine the data, which ever set I add second sums the full year rather than the mo...
Need Help
HuntBA2's avatar
HuntBA2
Regular Visitor
7 years ago

Ok sorted that issue, i needed to change table3 to Workshop!

 

So I'm now still having the same issues, what relationship did you create between the 2? I have tried linking dates etc and i'm still getting the same error

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi HuntBA2

    Please pay attention to my first reply.

    firstly, don't keep any relationship between "workshop" and "workshop plan" tables.

     

    Best Regards

    Maggie

    • HuntBA2's avatar
      HuntBA2
      Regular Visitor
      7 years ago

      OK - I'm a bit confused, if I remove any relationships I still have the same issues, is there another elationship your referancing in your 3rd bullit?

       

      3.edit relationship between "new table" and "workshop plan" table

      then drag "date" and "plan" from "workshop plan" table, "invoice value per month" from "new table" onto the visual on the report.

       

      To clarify, the relationship I set up was between the plana nd new table.

       

      Thanks

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi HuntBA2

        Sorry for my bad statement, let me edit it again

        1. firstly, don't keep any relationship between "workshop" and "workshop plan" tables.

        create calculated columns in the "workshop" table

        month1 = CONCATENATE(CONCATENATE(YEAR([invoice date]),"-"),MONTH([invoice date]))

        month = CALCULATE(MIN([invoice date]),ALLEXCEPT(workshop,workshop[month1]))

        invoice value per month = CALCULATE(SUM(workshop[invoice value]),ALLEXCEPT(workshop,workshop[month]))

        2.create a new table with the "workshop" table

        new table = SUMMARIZE(ALL(workshop),[month],workshop[invoice value per month])

        3.edit relationship between "new table" and "workshop plan" table

         

         

        then drag "date" and "plan" from "workshop plan" table, "invoice value per month" from "new table" onto the visual on the report.

         

        Best Regards

        Maggie