How to make PowerBI gets dates in a row instead of a column

[Anonymous]

Hello everyone.

I´m new to PowerBI so my situation is this.

As shown on image 1, I have a table which has dates set as column headers, for the purpose of the data. However when I connect data, software doesn´t recognize this headers as dates and doesn´t make the usual summary (day, month or year options) as placed on image 2.

Is there a way PowerBI acknowlegde dates in rows instead of columns

1

2

Many thanks!

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

If after importing data, it shows as below, please select other columns except the dates columns, then unpivot columns

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous - Could be wrong, but seems like you need to unpivot your date columns in Power Query editor.

[Anonymous]

First of all many thanks for the quick reply!

The thing is Greg, that the dates are not in a column, but in a row and that is how I would like them to be. 

I can unpivot dates but what you recommend to place as header? 

[lbendlin]

If this is how you would like them to be then you cannot use Power BI. Keep using Excel.

If you want the data to be usable in Power BI then you will want to follow Greg's advice.

[watkinnc]

You could use the UI function Use Headers As First Row, which is Table.DemoteHeaders.