Show Text in the Values Section of Pivot Table

If you're familiar with Pivot Tables, then you'll know that numbers only show up in the values section...most of the time.  However if you wanted to put text in the values section, there is a workaround.  One involves custom formatting, but it's limited to three text entries (that are aligned to positive, negative and 0 values).  Another workaround will be covered in this video and it involves using the Data Model and a DAX function called CONCATENATEX.  See the video to learn about this tip.


🔔 SUBSCRIBE to my channel  ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear  ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜  https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜  https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

• #education
• #pivot_table
• #training
• #beginners
• #learn
• #microsoft
• #display
• #text
• #simple
• #dax
• #tutorial
• #easy
• #excel_2016
• #formula
• #computer
• #excel_youtube_channel
• #dough
• #how_to
• #msoffice
• #101
• #windows
• #value
• #learn_excel
• #pivot
• #desktop
• #system
• #tip
• #doug
• #data
• #basic
• #numbers
• #power_query