Forum Discussion
Calendar Table Issues with Visual Information
Dear Community,
To get started, I created my calendar table in Query Editor and when relating the calendar table I do it with the dates of my fact table.
As I create my calendar table:
= FACT_SOBRETIEMPO [START PERIOD]
= #date( Date.Year(List.Min(Source)),01,01)
= #date( Date.Year(List.Max(Source)),12,31)
= {Number.From(Custom1).. Number.From(Custom2)}
Then I convert to board... As you can see in the image below:
The problem is that when I make a bar chart and place the month, the information for the last month does not appear:
For that matter, I should visualize the information for November but it does not happen even though there is information in my fact table.
What can I do to visualize the complete information?
I would greatly appreciate the help
2 Replies
- Ashish_MathurSuper User
Hi,
You do not see November there because it does not have 31 days. I create the calendar Table in the Data Model with the CALENDAR() function.
- Syndicate_AdminAdministrator
MY calenary table has the days correctly, I do not understand very well what you want to explain ...