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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
chaase
New Member

Power BI Calendar

Hi, I want to create a dashboard that tracks holiday calendars across multiple companies. Basically, I want a few columns on the side with the company, region, timezone, etc from one data set then using the DAX calendar function I have sourced all the dates within this year. However, I cannot figure out how to get the dates to run along the top horizontally as column headers with null values. I have tried transforming the data, using the add columns command and playing around with matrixes. Still, it seems there is an error when integrating the calendar values with my original data set each time. Any advice would be appreciated.

1 REPLY 1
lbendlin
Super User
Super User

I cannot figure out how to get the dates to run along the top horizontally as column headers

Please don't.  If you need to display it that way (which hopefully you don't either) then let the matrix visual do that for you.

 

Whenever you see a horizontal scrollbar in a visual you know that you have messed up.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.