Forum Discussion

Jon54's avatar
Jon54
Frequent Visitor
4 years ago

Scatter chart sums values

Hello, 

If I create a scatter chart, I must sum the x and y axis as I have 'AreaName' in 'Values'. If I link 2 tables (one to many) the chart sums all the values from the dimension table:

However, if I merge the 2 tables so the x-axis values are now in the main table, I get what I would expect:

I was under the impression that creating a one to many relationship would be better for memory but I don't know how to get round this summing issue.

Would anyone have any advice?

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Jon54 , Scatter visual can take Measure on both X and Y axis, So best to use 2 measures. You can take one of the axis values as not summarized like line/bar visual axis

     

    1-M should work fine. But can you share data model for reference?

    • Jon54's avatar
      Jon54
      Frequent Visitor
      4 years ago

      Hello amitchandak ,

      Thanks for your help. It was more to do with the fact the x-axis was summing all values and I didn't want it to. I have managed to solve this just by using the area name from the dimension table rather than the fact table.