Laura from Nashville is looking for a way to make sure that all future pivot tables default to having No Subtotals. This *was* a feature in the PowerPivot Add-in back in Excel 2010, but then was removed. However, thanks to Pivot Table Defaults, you can force all future pivot tables into a flat pivot table that is ready for re-use.
Category: Power Query
The Tale of Two Caches
Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain!
DAX Studio 3
https://daxstudio.org
Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: rel=”nofollow”>https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #Performance #GuyInACube
Merging your data in a modern lakehouse data warehouse
Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps.
Stijn Wynants
https://twitter.com/SQLStijn
pyspark.sql.SparkSession.createDataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.SparkSession.createDataFrame.html
Table deletes, updates, and merges
https://docs.delta.io/latest/delta-update.html#language-python
Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— <a Continue reading “Merging your data in a modern lakehouse data warehouse”
Awesome Way To Replace A Very Long Slicer in Excel – 2509
What if you have an Excel Slicer with hundreds of values? Today, an awesome trick from Tine at Zebra BI that allows you to replace that huge slicer with one cell.
Table of Contents
(0:00) Welcome
Where is DARK MODE in DAX Studio 3??? #shorts
Not going to lie, it took me a bit to find the button to switch to Dark Mode in DAX Studio 3. Here’s where it is!
#shorts #PowerBI #GuyInACube
Exploring Excel IMAGE Function – 2500
Display pictures on your Excel Dashboard using an Excel IMAGE formula. This episode has a deeper dive into the function and how to use it.
(0:00) Welcome
(0:24) Finding Image Address
(0:54) Building Image URL
(1:30) Using IMAGE function
(1:52) Hover for Pop-out Image
(2:30) Pivot Table
(2:55) Formula to Display All Images
(3:04) FILTER to convert to array
(3:15) IMAGE function
(3:20) TRANSPOSE for 2501 Bug
(3:35) WRAPROWS function
(3:45) Excel MVP by Country
(4:10) Caption under picture but how?
(5:19) Caching images #BUSY! error
(5:57) Insiders beta now
Keep Leading Zeroes When Opening CSV – 2502
D on YouTube asks: How do I stop Excel from removing leading zeros when opening a file?
Changing a column from general to text does not work for me, as the “0” has already been removed.
09805 becomes 9805, for example.
The files I’m opening does not make it clear that the zero has been removed.
I’m working in spreadsheets with 200k rows.
So stopping Excel from removing them in the first place, would be preferable
Bug Or Feature? Excel’s WRAPROWS 2501
While working on video 2500, I ran into something that seems buggy with the WRAPROWS function in Excel. Is it a bug? Or a Feature?
Four New Excel Features Debut!
Wyn’s book for shipment to USA:
https://mrexcel.e-junkie.com/product/1750249/Power-BI-for-the-Excel-Data-Analyst-Print-Book-to-USA-Only
This video covers six exciting things:
1) The Show Changes feature which had been in Excel Online is now in Desktop Excel
2) Data Validation partial matching is working again
3) There is a new look for Excel Options
4) A new IMAGE function comes to Excel to display an image
5) Wyn Hopkin’s new Power BI for the Excel Analyst book… it drops on November 1, but I have 3 cases to ship now…. US only.
6) The 14 functions for text and array manipulation are coming to general availability.
Table of Contents
(0:00) Four new features today
(0:54) Show Continue reading “Four New Excel Features Debut!”
Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?
You have different options in Power BI when it comes to slicers and filters. Just put the slicer on the report, use a slicer panel or have them in the filter pane. But which one is faster??? Patrick explores a few scenarios to think about!
Should you hide the filter pane in Power BI?
https://greyskullanalytics.com/should-you-hide-the-filter-pane-in-power-bi/
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— <a Continue reading “Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?”
🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)
Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training Continue reading “🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)”
Simulate Hierarchies with Field Parameters in Power BI
Struggling with field parameters and hierarchies in Power BI? They just don’t work! Patrick has an approach that looks to simulate hierarchies by using field parameters in this way.
Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Simulate Hierarchies with Field Parameters in Power BI”