POWER BI does not show any data in data section

[chrisgehm]

Hi!

I'm just starting using POWER BI, and I have the following problem:

I have an excel file with some data.

One of the columns contains Months (it can be numeric or in text: 1 or January, for example)

When I want to make a graph first of all, the months are sorted as text or number, not by month.

So I wanted to convert that column to date, but when I got to the data section I can't see any data:

How can I solve this?

Sorry for my bad English.

Kind regards.

[v-sihou-msft · Accepted solution]

@chrisgehm

No, it's not possible. For a month, it can never be stored as a date type. You can only store it in either text or numeric type.

Regards,