Forum Discussion

aliyahussein's avatar
aliyahussein
Regular Visitor
5 years ago

Time Intelligence is not working

Hi,   I am having issues with time intelligence in the advance power query. I have updated the parameter with the apporiate time range. The start date is 2019 and the end date is 2021. The data is ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi aliyahussein 

 

I don't think the issue is in the Power Query. The M codes in your post are to create a Date table. And the data values which populates the column chart must come from another table (e.g. a Fact table). Do you create relationship between Date table and Fact table? Which table does the Axis field of this column chart come from? Does Fact table have data in Year 2021?

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.