Forum Discussion

waleed111's avatar
waleed111
Icon for Helper V rankHelper V
6 years ago

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 relat...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
5 years ago

Hi waleed111 ,

 

The reason why the Blank Values appears may be it hasn’t matched with all the row values in these tables. You may change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table. Then when you make some changes or interact in someone table, the other table objects will return corresponding matched result.  See more:Create and manage relationships in Power BI Desktop .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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