Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 updated with the dimensions dates, but the issue is the data is not updating on my visuals. So I am not 100% sure where the issue lies. Please see snips.
Time intelligence:
Parameter:
Visuals:
Based on the visual you can see that 2021 is no there. This is my issue.
Thing helps!!
Without knowing the measures that might make up your visual, a couple notes:
Real time intelligence requires your date table to include dates for the full year of your first and last dates -- in this case, 1/1/2019-12/31/2021.
But if your first date in the date table is 10/1/2019, then how do you have what appear to be 12 months of 2019 day on your visual? Also, I would double check the filter pane.
But it seems that you have dates in the fact table not present in the date table, or vice versa. A sample of your fact table would make this a lot easier to solve.--Nate
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.
If there are no results for the dates in 2021 in your visual, then they will be automatically filtered out. You can look at the Data View to confirm that the 2021 dates are in your date table.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I checked my data view and 2021 is there. Do you think it can be something else?
Thank you,
Aliya