Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

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.

lcoronado1988_2-1672346439854.png

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:

lcoronado1988_1-1672346389495.png

The problem is that when I make a bar chart and place the month, the information for the last month does not appear:

lcoronado1988_0-1672346226920.png

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 2
Syndicate_Admin
Administrator
Administrator

lcoronado1988_0-1672403173133.png

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

Ashish_Mathur
Super User
Super 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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.