Pivot Table Design Tricks

[@GoodlyChandeep]

Download the Excel file here ⬇ - goodly.co.in/pivot-table-design-tricks-in-excel 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/- goodly.co.in/power-bi-beginner 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 - goodly.co.in/learn-dax-powerbi

[@alexrosen8762]

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

[@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"

[@jon99long]

Only one word to describe this. Awesome!!!

[@chrism9037]

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

[@KimzCraftz]

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

[@dineshwagle9832]

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

[@krishna6296]

Thank you for posting valuable content.

[@ahmedoufkir8235]

Thank you Chandeep for these video

[@williamarthur4801]

Nice to see some power pivot.

[@odallamico]

Excellent tricks. Thank for sharing

[@MrDhunpagla]

Awesome dashboard..Thanks for sharing

[@gennarocimmino]

Absolutely outstanding. Thank you very much for sharing

[@vacilando86]

Thanks for your helpful content

[@banhcu0n]

great video as usual, thank alot

[@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.

[@eslamfahmy87]

Awsome as usual good job

[@Thangdoan2611]

It’s helpful. Thank you❤

[@pondyanand]

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

[@josealvesferreira1683]

Very good

[@sandipsoni4047]

Thank you chandeep

[@imranshethwala1492]

Thank you very much Sir

[@3danim8r1]

Nice Video

[@dirkstaszak4838]

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

[@Paladin101]

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 🤬

[@KatieTerrell-o8d]

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!

[@mogarrett3045]

excellent

[@gurvindersingharora5301]

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

[@eslamfahmy87]

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.

[@eslamfahmy87]

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

[@txreal2]

Saved me 1,000 clicks 😅

[@Nalaka-Wanniarachchi]

Thumbs Up.!!!

[@SSi-nq3rt]

i wonder why i‘ve forgotten it all 😮

[@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?

[@GoodlyChandeep]

an extra or missing bracket

[@chasingdogs]

@@GoodlyChandeep Thank you good sir.

[@victor_wang_1]

I was laughing every time the zoom went back to the default when you try to enter through the intellisense. Power Pivot badly needs an update.

[@GoodlyChandeep]

damn i know! you sensed my despair