Forum Discussion
Helper VRelationship 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 relationships:
so what is the problem and what is the 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.
4 Replies
- amitchandak
Super User
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...
waleed111i didnt understand your point, please more explanation.
v-lionel-msftCommunity Support
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
