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!!!
Excellent video Chandeep, very well-explained.
Thank you Chandeep for these video
You're right. That looks awesome! Thanks for sharing.
Thank you, you made that look so simple.
I'm gonna have to go upgrade all my dashboards now
Thanks for your helpful content
Absolutely outstanding. Thank you very much for sharing
Thank you for posting valuable content.
Excellent tricks. Thank for sharing
Great video. I can use some of these tricks in my work. Thank you, Chandeep!
Awesome dashboard..Thanks for sharing
It’s helpful. Thank you❤
Nice to see some power pivot.
Very good
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.
Thank you very much Sir
great video as usual, thank alot
Awsome as usual good job
Thank you chandeep
Great video once again ! It would be helpful if you can callout what's not possible in Mac.
Nice Video
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!
Thnx a lot but if the status column as text instead number . How we can applay kpi accordingly
excellent
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 🤬
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.
Bhai,
Please make a video of summarize and addcolumn together usage basic to Advanced
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.
Saved me 1,000 clicks 😅
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