Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

months in the columns rather than in the rows

Good morning,


I am trying to create a table similar to picture  1 in which the months are in the columns. However, in the new model, I have a fact table as a calendar and the months are in rows (picture 2), and I would like to have them in the column, any idea how I can do it with a table rather than a matrix?


Thank you in advance


Picture 2                    Picture 1
Picture 2Picture 2Picture 1Picture 1

Super User
Super User

Hi @miriambb,


A Matrix is going to be the easier way, is there a reason you're not wanting to use one?


To get that in a table you'd need to create a measure for each month and add them all in to the table. However, you wouldn't be able to dynamically filter the columns (such as by year) and you'd have to add a new measure for each new month.

Hi Antonio!

Thank you for your help!

I actually managed to do it with a table and flat the hierarchy and now as a Matrix


Thank you for your helo!


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors