https://community.fabric.microsoft.com/t5/Developer/Power-BI-Calendar/m-p/4035807#M54116 <P>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.</P> Thu, 11 Jul 2024 01:32:11 GMT chaase 2024-07-11T01:32:11Z https://community.fabric.microsoft.com/t5/Developer/Power-BI-Calendar/m-p/4035807#M54116 <P>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.</P> Thu, 11 Jul 2024 01:32:11 GMT https://community.fabric.microsoft.com/t5/Developer/Power-BI-Calendar/m-p/4035807#M54116 chaase 2024-07-11T01:32:11Z https://community.fabric.microsoft.com/t5/Developer/Power-BI-Calendar/m-p/4038044#M54141 <LI-CODE lang="markup">I cannot figure out how to get the dates to run along the top horizontally as column headers</LI-CODE> <P>Please don't.&nbsp; If you need to display it that way (which hopefully you don't either) then let the matrix visual do that for you.</P> <P>&nbsp;</P> <P>Whenever you see a horizontal scrollbar in a visual you know that you have messed up.</P> Thu, 11 Jul 2024 20:57:20 GMT https://community.fabric.microsoft.com/t5/Developer/Power-BI-Calendar/m-p/4038044#M54141 lbendlin 2024-07-11T20:57:20Z