I'm new to using PowerPivot but very proficient in Pivot Tables. I've imported data from a CSV file, all the whole data set came in as TEXT columns. I then set the Data Types to Decimal, Whole Numbers, Dates, etc and I also set the formats respectively.
However, when I finally get to the subset of data and want (using slicers), when I pull the details for distribution (show details), it pulls all the correct rows but the column details all as TEXT format. They are: Left aligned, Text, and in the blue and white bar link table, and I can't get the format fixed by manually trying to change them. I don't want to have to copy and paste values and then convert all columns again. Any insight is appreciated!
However, when I finally get to the subset of data and want (using slicers), when I pull the details for distribution (show details), it pulls all the correct rows but the column details all as TEXT format. They are: Left aligned, Text, and in the blue and white bar link table, and I can't get the format fixed by manually trying to change them. I don't want to have to copy and paste values and then convert all columns again. Any insight is appreciated!