Problem with Date grouping

[PradipMCT]

Hi Everyone,

I need a quick help. I have downloaded the FB page data of a company. I would like to use some time intelligence function, for that, I have created a custom date table using Calendarauto() Function. I created a relationship between the custom date table and FB table. I created a relationship, that turned out to be 1 to 1 relationship automatically. 

Now when I drag date into the canvas of the report section, it gives the year, qtr, month and day hierarchy. However, I delete everything but keep years, now when I drag the data from Likes, comments & shares column it doesn't group the date properly. PFB in the screenshot

Screenshot. please help asap. 

[v-yuezhe-msft · Accepted solution]

Hi @PradipMCT,

The screenshot you post is not visible. Could you please share sample data of your tables for us to analyze?

In addition, based on my test, after I use Calendarauto() to create a date table  and create a visual, everything works well. The numeric column in my test table is grouped by date properly even if I only keep years in date hierarchy .



Thanks,
Lydia Zhang

[PradipMCT]

The above report, the rest of the years are not visible and only 2014 and 2016. Why?