Forum Discussion
chrisgehm
Helper III
Helper IIIPOWER BI does not show any data in data section
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.
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,
1 Reply
v-sihou-msftMicrosoft Employee
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,