Forum Discussion

waleed111's avatar
waleed111
Icon for Helper V rankHelper V
5 years ago
Solved

Relationship and filter

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 relation...
Need Help
  • waleed111's avatar
    waleed111
    5 years ago

    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.

     

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
waleed111
Icon for Helper V rankHelper V
5 years ago

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.