Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

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

  • 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.

  • MY calenary table has the days correctly, I do not understand very well what you want to explain ...