Pivot Table Design Tricks

In this video, you'll see how to turn a basic pivot table into an interactive report in Excel. We’ll work with Power Pivot to build a model, add calculations, and apply a few formatting tricks to make it visually appealing.

By the end, you'll have a pivot table that not only looks great but is also easy to use for deeper analysis.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[GoodlyChandeep]

Download the Excel file here ⬇ -

If you're just starting out with Power BI and want to learn from the basics in a structured way, consider the beginner course available for only $9 | INR 499/-

Already familiar with Power BI and ready to level up? Check out the DAX and Data Modeling course to build advanced reports and solid data models -

[alexrosen]

Wow! Best pivot tutorial I have seen so far 👌🙏👌

[jonlong]

Only one word to describe this. Awesome!!!

[chrism]

Excellent video Chandeep, very well-explained.

[DinoDelight]

Thank you, you made that look so simple.
I'm gonna have to go upgrade all my dashboards now

[dineshwagle]

Great video. I can use some of these tricks in my work. Thank you, Chandeep!

[KimzCraftz]

You're right. That looks awesome! Thanks for sharing.

[Bhavik_Khatri]

Excellent tutorial.
You can update Pivot table defaults steps listed below.
1) Files-> Options->Data->Edit defaults Layout
2) Report Layout->"Show in Tabular Form"
3) Pivot Table Options-> uncheck "Autofit Column widths on update

Alternatively
1) If you have Pivot Table with changes you like then Select Pivot Table
2) Click on "Import"
3) Click on "Ok" then Click "Ok"

[krishna]

Thank you for posting valuable content.

[RonDavidowicz]

Nice video! Good practical use for power pivot.

It’s too bad that the slicer doesn’t “float” so you can keep the product slicer in view while scrolling down.

[gennarocimmino]

Absolutely outstanding. Thank you very much for sharing

[pondyanand]

Great video once again ! It would be helpful if you can callout what's not possible in Mac.

[KatieTerrell-od]

This is a great video, thanks! I have a quick question, though - why did you opt to create the Calendar table in Power Query instead of using the Date table feature in Power Pivot? Does it provide you more flexibility if you create it with the script in PQ? Thanks!

[dirkstaszak]

Great as usual ❤ just wondering why you used an if statement for the ytd formula?

[Paladin]

I am right with you when it comes to the autofit column width! Worse still is that I always forget to uncheck it until it’s too late 🤬

[gurvindersingharora]

Bhai,
Please make a video of summarize and addcolumn together usage basic to Advanced

[eslamfahmy]

Thnx a lot but if the status column as text instead number . How we can applay kpi accordingly

[DivyaBhagchandani]

Hello.. need help. I have prepared a data model .. now I want to have a data validations for some of my columns. How can I have that.

[eslamfahmy]

Hi, thnx a lot but i can't understand your variance return related (&&) could you explain

[chasingdogs]

Hi, I was wondering how to do YoY in DAX... however, while I trying to incorporate the formula in my sheet, it's returning error after error.. I am complete noob in this field and the check formula in measure is like Klingon..it says the syntax for ")" is incorrect.... wtf am I doing wrong?