One of these four shortcut keys stops working in Windows versions of Excel:
Ctrl+9 to hide rows
Ctrl+Shift+9 to Unhide rows
Ctrl+0 to hide columns
Ctrl+Shift+0 to unhide columns
If the last one is not working for you, it is because the Windows shortcut to switch language is assigned to Ctrl+Shift. This video shows the Control Panel setting to make Ctrl+Shift+0 or Ctrl+Shift+) start unhiding columns again.
Understanding the sales breakdown between new and steady customers is crucial to gain valuable insights into your business’s performance. It helps you identify which customer segment is driving revenue growth and which needs attention.
By utilizing advanced Power BI analytics, you can achieve this breakdown and unleash endless analysis potential to optimize your business strategy and maximize profitability. In this tutorial, Sam will show how you can effectively and dynamically evaluate new customer sales.
*****Video Details*****
00:00 Introduction
00:54 The objectives
02:24 Identifying new customers
04:20 New customer sales
07:44 Percentage of new customer sales
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “Evaluating New Customer Sales – Advanced Analytics in Power BI [2023 Update]”
A decision tree is a data mining technique used in Power BI to visualize a sequence of decisions and its possible outcomes. It helps users understand the factors that affect a specific outcome and identify the most effective decision path.
By learning how to use decision trees in Power BI, users can make more informed and data-driven decisions that lead to better business outcomes. In this video, Gaelim is going to demonstrate how to use a decision tree classifier to help distinguish between 2-3 types of classes.
*****Video Details*****
00:00 Introduction
00:33 Case scenario
03:54 Data set
04:38 Bringing in data
05:35 Decision tree
06:58 Python script
***** Continue reading “How To Use A Decision Tree To Predict Classes In Power BI Using Python”
Download Zipped Folder with All Files: https://excelisfun.net/files/15-M365ExcelClassVideoFiles.zip
This video teaches how to use the 7 types of Joins when you use Merge in Power Query. Many easy to understand examples.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:19) Defined the 7 types of Merge Joins in Power Query
3. (02:48) Accessing Merge Join in Excel, Power BI Desktop or Dataflows
4. (03:02) Files for Power BI example
5. (03:17) MUST use Queries NOT Excel Continue reading “7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15”
In this video, Brian is going to share one of the new features in the Power BI February 2023 Updates — the Conditional Formatting Based On String Fields. This new feature has been added to allow users to set conditional formatting rules based on string fields, which was highly requested. This new capability can be accessed through the formatting pane dialog, allowing for conditional formatting of column chart colors, among other things. Watch as Brian demo this new feature.
*****Video Details*****
00:00 Introduction
01:06 Data set
01:34 Conditional formatting
02:35 Field value
03:34 Advantages in using SWITCH TRUE
05:29 Text operators
05:58 Complex conditions
06:23 Dynamic highlighting of outliers
08:04 Continue reading “How To Use Conditional Formatting Based On Strings Fields – Power BI February 2023 Updates”
How to sum the top 5 values in excel?
How to sum top 5 in excel?
The question is how to sum the top 5 in Excel, but I create something here that can the top N values.
In this tutorial, Sam will show how you can use Power BI’s ROW and UNION functions to create tables. This flexible technique can be used with user input or imported calculations to create dynamic tables. The approach allows you to hard-code results or automatically update tables based on changes in the underlying data. With this technique, you can create custom tables to meet your specific needs and easily visualize data in new ways.
*****Video Details*****
00:00 Introduction
01:27 Using ROW to create a sorting table
02:40 Combining ROW with UNION
05:02 Segmenting customers
05:40 Virtual table
09:08 Filtering the dates table
10:11 Conclusion
***** Learning Power BI? Continue reading “How To Create Tables By Combining UNION and ROW Functions In Power BI [2023 Update]”
Today’s question from Bill.
Did you know that Excel’s Advanced Filter is returning partial matches?
A phrase in the criteria range is treated as Phrase*.
This is an annoying problem.
Excel Help sort of alludes to this problem and suggests a formula in the criteria range of Advanced Filter. But if you try to automate the creation of those formulas in the criteria range, it does not work.
In this video, a convoluted set of steps to automate formula creation with a carat in place of the equals sign, then Replace to change the text into a formula. This allows the Advanced Filter to work.
This Continue reading “Why Is Excel Advanced Filter Using Partial Matching 2388”
How to sum only the positive numbers in Excel?
This video shows how to use SUMIF or SUMIFS.
This video matches these search terms:
how to calculate sum of only the positive numbers in excel
how to do a sum of only positive values in excel
how to sum negative and positive total numbers in excel
how to sum positive and negative in excel
Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!!
Composit model permission blog (Older information):
https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/
📢 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/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – rel=”nofollow”>https://guyinacube.com/tools/
#PowerBI #Permissions #GuyInACube
A question from my Daytona Beach seminar last week:
We know XLOOKUP can find the number just larger or just smaller than a number. But does this also work with Text? How about with Symbols?
In this video, Bill Jelen shows how the approximate match works with XLOOKUP. Unlike MATCH or VLOOKUP, the table does not have to be sorted. You can find a value just smaller or just larger than the search value.
This also works with Text, although it is case insensitive.
And, it works with symbols, but in an unexpected sequence.
Learn how Microsoft Lists / SharePoint Lists can take advantage of Power BI! Daniel walks through how easy it is to start using today!
Create a report quickly from a SharePoint list or library
https://learn.microsoft.com/power-bi/create-reports/service-quick-create-sharepoint-list
Daniel Glenn:
https://twitter.com/DanielGlenn
https://www.linkedin.com/in/danielglenn/
https://365mcs.com/
https://www.youtube.com/365mcs
📢 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
— Continue reading “The POWER of Microsoft Lists and Power BI”