Relationship and filter

[waleed111]

When i try to use date column as axis in my chart it not work and gave me blank for all values, this is the chart:

  and this is the axis and values:

 and this is the model and relationships:

 

 

 so what is the problem and what is the solution?

[amitchandak]

@waleed111 , one of the reason for that that you have fewer dates in date table. Default is a right join from one to many sides. I am hoping the date is coming from the date table. If not you have null dates in your table Device_man...

[waleed111]

i didnt understand your point, please more explanation.

[v-lionel-msft]

Hi @waleed111 ,

This problem?

Do you mind sharing your .pbix file? If yes, please show the sample data of the three tables(You just need show the columns are used in the visual.)

Best regards,
Lionel Chen

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

[waleed111 · Accepted solution]

Thank you msft, the problem happened because some date column have datetime data type while another have date type, then i make all of them date type then the problem solved.