I need help with power pivot and data model. I'm in the process of building a LMS for my department. I'm creating a pivot table to help the IT guys input the curriculum and the training matrix into the LMS. However, I have been unable to make power model and pivot to display text in value field. For context, all of my data is text based (e.g. course titles, course code such as XYX-1234, titles of positions, job prescriptions, etc.) and there are no numerical values at all. I tried setting up measures to so pivot table can read text, but It only works for couple of columns then, whatever additional measures I add are deemed as invalid by excel. How can I fix this? Thank you!