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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi waleed111 - can you validate if all the dates in your FACT table are available in the Date table?

Power BI will not be able to identify Quarters for dates that are not available in the data table

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

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

I make date column using CALENDARAUTO then i connect it with another date column in another table but the relation didn't work.