How to show text in values area of Pivot Tables
19.7 هزار بار بازدید -
2 سال پیش
-
Pivot Table values (data) area
Pivot Table values (data) area can only show numbers.
Learn how to show text instead. Two different methods:
1. Using Conditional Formatting
2. Using a DAX measure
Also learn how to apply Conditional Formatting properly to Pivot Tables.
Pivot Table Masterclass : https://s.efficiency365.com/ptyt
📝 Table of Contents
0:00 Introduction
0:27 Conditional Formatting method
2:31 DAX formula method
4:21 Conditional Formatting in Pivot Tables - the right way
6:49 Summery
📺 Microsoft Teams Simple Best Practices 2023: Microsoft Teams - 15 Best Practices 2...
📺 How to convert crosstab data into tabular format - multiple headers and blocks : Convert crosstab data to tabular - Ex...
I am always creating more Office365 tutorials, so let me know in the comments about other topics you'd like to see videos for.
🔔 Subscribe to my Channel: @efficiency365
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
#efficiency365 #excel #office365
Learn how to show text instead. Two different methods:
1. Using Conditional Formatting
2. Using a DAX measure
Also learn how to apply Conditional Formatting properly to Pivot Tables.
Pivot Table Masterclass : https://s.efficiency365.com/ptyt
📝 Table of Contents
0:00 Introduction
0:27 Conditional Formatting method
2:31 DAX formula method
4:21 Conditional Formatting in Pivot Tables - the right way
6:49 Summery
📺 Microsoft Teams Simple Best Practices 2023: Microsoft Teams - 15 Best Practices 2...
📺 How to convert crosstab data into tabular format - multiple headers and blocks : Convert crosstab data to tabular - Ex...
I am always creating more Office365 tutorials, so let me know in the comments about other topics you'd like to see videos for.
🔔 Subscribe to my Channel: @efficiency365
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
#efficiency365 #excel #office365
2 سال پیش
در تاریخ 1401/10/27 منتشر شده
است.
19,756
بـار بازدید شده