Date format and filtering in Powerpivot tables

Welcome, Guest

Please ask here your questions related to DAX and PowerPivot for Excel or PowerPivot for SharePoint. To post your question or reply you need to login first!

Reply Topic

New Topic

Page:
1

TOPIC: Date format and filtering in Powerpivot tables

Date format and filtering in Powerpivot tables 1 year, 6 months ago #142

wicksyc
OFFLINE
Fresh Boarder
Posts: 5
Karma: 0

Hi All

Well I think I have got over my data corruption problem and everything seems to be working well except when I create a pivot table from powerpivot tables the "date" field from one of the tables comes thru as a label and consequently I dont get the "date type" filters, I get text filters. I tried using the =format formula in a calculated field but now it comes thru and I have label type filters still not date type filters.

Any ideas
Wicksyc

Reply Quote

Re:Date format and filtering in Powerpivot tables 1 year, 6 months ago #149

kjonge OFFLINE Fresh Boarder Posts: 6 Karma: 0	can you try to change the column type in the PowerPivot Window. When you select the column you can manually set the data type to date.
	Reply Quote