Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
The above report, the rest of the years are not visible and only 2014 and 2016. Why?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |