Solved: Month Column

henryhuynhpham · ‎10-23-2023

I have not been using Power Bi for a while so I am kinda rusty. Currrently I have 4 Excel files of 4 continuous months and they all do not have a month column. I have manually combined them into one file and added a month column for visualization and apparently Power BI does not pick up on that. I tried to change the type from text to date but I gave me an error and can't convert it. Anyone has any idea how to fix it?

Jihwan_Kim · ‎10-23-2023

Hi,

One of ways to achieve this is to have a Calendar Dimension Table, connect it to the fact table, and get the Month name column from the dimension table for visualizations.

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Jihwan_Kim · ‎10-23-2023

Hi,

One of ways to achieve this is to have a Calendar Dimension Table, connect it to the fact table, and get the Month name column from the dimension table for visualizations.

Thank you.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Month Column

Helpful resources

Power BI Dataviz World Championships

Power BI Monthly Update - December 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta