Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Every visualisation shows same value despite relationship

Dears,

 

I have a simple data model with 2 tables:

- one containing project ID's and their sold turnover

- one containing that same project ID and a creation date

 

 

 

I now want to create a visual showing me the turnover per month, but it returns the same value for every month. I'm lost as to what I do wrong.

 

 

  • Hi Anonymous 

     

    Whas is the Cross Filter Diresction of that relationship? Have you set that on Both and check the report?

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn: 
    www.linkedin.com/in/vahid-dm/

     

     

2 Replies

  • Hi Anonymous 

     

    Whas is the Cross Filter Diresction of that relationship? Have you set that on Both and check the report?

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn: 
    www.linkedin.com/in/vahid-dm/

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi VahidDM 

     

    That's indeed the solution, thanks! Could you explain to me what's the reasoning behind this?