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
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"
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.
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!
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?
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
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"
Wow! Best pivot tutorial I have seen so far 👌🙏👌
Only one word to describe this. Awesome!!!
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.
Excellent video Chandeep, very well-explained.
Thank you Chandeep for these video
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 🤬
Great video. I can use some of these tricks in my work. Thank you, Chandeep!
Thank you, you made that look so simple.
I'm gonna have to go upgrade all my dashboards now
Great video once again ! It would be helpful if you can callout what's not possible in Mac.
Thank you for posting valuable content.
Nice to see some power pivot.
Thanks for your helpful content
Great as usual ❤ just wondering why you used an if statement for the ytd formula?
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!
Excellent tricks. Thank for sharing
Very good
Thank you chandeep
Absolutely outstanding. Thank you very much for sharing
You're right. That looks awesome! Thanks for sharing.
Nice Video
Awesome dashboard..Thanks for sharing
Bhai,
Please make a video of summarize and addcolumn together usage basic to Advanced
Awsome as usual good job
Thank you very much Sir
It’s helpful. Thank you❤
great video as usual, thank alot
Thnx a lot but if the status column as text instead number . How we can applay kpi accordingly
excellent
Saved me 1,000 clicks 😅
Hi, thnx a lot but i can't understand your variance return related (&&) could you explain
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.
Thumbs Up.!!!
i wonder why i‘ve forgotten it all 😮
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.
damn i know! you sensed my despair
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?
an extra or missing bracket
@@GoodlyChandeep Thank you good sir.