Feb 03 2022 04:47 AM
Hello Experts,
I have a pivot.
I want to add a field to the column but when I do, the appearance is not as expected. I choose "Columnar" but it doesnt change anything.
The field is text and I think that is the issue.
Little difficult to explain but if you open the attached file and drag in "Status" I think it will become apparent what I am referring to.
thank you
Feb 03 2022 05:18 AM - edited Feb 03 2022 05:19 AM
Solution@Tony2021 Then you need to use Power Pivot (i.e. a pivot table via the Data Model). You need to create a DAX measure that enables you to report text values (like Status: Pending/Done) in the Value field of the pivot table.
See attached.
Feb 03 2022 07:50 AM
Feb 03 2022 08:13 AM - edited Feb 05 2022 10:29 PM
@Tony2021 What I did is create a pivot table and check the box "Add to data model".
Then you need to go to the Power Pivot ribbon and add a measure. Am not sitting in front of a computer where I can do that to guide you (on a Mac, sorry). But if you find some on-line instructions on how to get into Power Pivot / Data Model and write measures, you should be able to "find" the measure I used to put the Status in the value field. If you can't, I can tend to it later or someone else can step in to help you.
Feb 03 2022 11:40 AM
If your work with data model PivotTable, Power Pivot is not necessary required. You may right click on table name to add measure
or right click on existing measure to edit it
Feb 03 2022 05:18 AM - edited Feb 03 2022 05:19 AM
Solution@Tony2021 Then you need to use Power Pivot (i.e. a pivot table via the Data Model). You need to create a DAX measure that enables you to report text values (like Status: Pending/Done) in the Value field of the pivot table.
See attached.