Sheet view in Excel is useful if multiple people are editing the same workbook. Say that one person wants to filter to Open orders and the other wants to see closed orders. One wants the data sorted descending and the Continue reading “How To Effectively Use Sheet View While Collaborating In Excel 2461”
Category: Power Query
Power BI Premium Gen2 updates (January 2022)
There are some updates for Power BI Premium Gen2 you should know about! Adam talks about the upcoming migration date and more! Are you ready for Gen2?
Plan your transition to Power BI Premium Gen2
https://docs.microsoft.com/power-bi/admin/service-premium-transition-gen1-to-gen2
Install the Gen2 metrics Continue reading “Power BI Premium Gen2 updates (January 2022)”
Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values
I know of nine ways in Excel to Paste Values.
One of these is about to be wiped out by Microsoft and the Excel team.
I think all nine of them are important!
Here are the nine ways that I know of to Continue reading “Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values”
The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460
The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.
Some of you Continue reading “The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460”
The Two Digit Year Setting Does Not Work If You Never Change It – 2458B
An update on video 2458. There is a setting about how Excel interprets a two-digit year. Microsoft changed this setting from 2029 to 2049. But Excel refuses to accept the 2049 setting. Unless you change the setting in Control Continue reading “The Two Digit Year Setting Does Not Work If You Never Change It – 2458B”
REPLAY Power BI tips from the Pros – LIVE (Jan 15, 2022)
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment Continue reading “REPLAY Power BI tips from the Pros – LIVE (Jan 15, 2022)”
Combining refresh and real time with Hybrid Tables in Power BI
Tired of having to wait for the next refresh to see current data in your Power BI Report? Hybrid Tables is here to help you! Patrick looks at how you can use this feature to have an imported table that Continue reading “Combining refresh and real time with Hybrid Tables in Power BI”
Excel TextBox With Many Columns – 2459
It is a little-known feature that you can automatically break the text in an Excel Textbox into multiple columns. Here is how to find the setting.
Add a little info to your Sparkline in Power BI
Have you checked out sparklines in Power BI? Patrick explores how to set them up and also how you can be creative with them to add additional context to your reports!
KPI Video:
https://www.youtube.com/watch?v=zHzSBNES6jE
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Add a little info to your Sparkline in Power BI”
Excel Fix 2029 Rule for 2-Digit Year – 2458
If you type a date with a two digit year, Excel treats anything up to 29 as being 2029. Once you get to 30, though, they assume you mean 1930. With 2030 only eight years away, it might be time Continue reading “Excel Fix 2029 Rule for 2-Digit Year – 2458”
Looking into the future of Power BI (2021)
The new release wave was published for Power BI! This is the roadmap for what is to come. Adam explores what it shows and what you can expect.
Microsoft Power Platform release plans
https://aka.ms/pbiroadmap
Power BI release plan report by Continue reading “Looking into the future of Power BI (2021)”
Intro to R with Power BI
You enjoyed the intro to Python video, now let’s look at R Script within Power BI! There are a lot of similar aspects and Patrick walks you though what you should know to get started.
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Intro to R with Power BI”