Learn more about the exciting news about the launch of Microsoft Fabric in this two-day digital event. From Power BI, to Synapse, and Data Factory, you will be able to learn what’s available to you in this new offering.
Blog: https://aka.ms/build-with-analytics
#MicrosoftFabric
Microsoft Excel Tutorial – how to draw a semi-circle in Excel.
The Insert Shapes drop-down menu in Excel offers an oval, but not a semi-circle. How can you draw a semi-circle? Most of those shapes include a yellow handle for changing the inflection point. You can use this handle to make the partial circle into a half-circle or quarter circle.
Download the workbook from today: https://www.mrexcel.com/youtube/U2gvZtUW0vk/
This short video shows you how.
Table of Contents
(0:00) Draw a semi-circle in Excel
(0:15) Yellow handle
(0:27) Rotation handle
This video answers these common search terms:
How to draw a semi-circle in Excel
How to draw a half Continue reading “Excel – Draw a Semi-Circle”
Microsoft Office Tutorial – live link to Excel range in Word.
Ashley wants to embed a range of Excel data in a Word document.
If the data in Excel changes (including adding more rows), she wants the Word document to update.
Annoying: If you use Insert, Object in Word, it captures the wrong range and truncates if you add more data.
My method: (1) Set the Print Range in Excel, (2) Select the Print range and Copy. (3) Paste to Word, (4) Open the paste drop-down menu and choose Linked Keep Source Formatting. This reliably works.
How do you solve this? Let me know down Continue reading “Excel – Embed Growing Range In Word Document – 2601”
Microsoft Excel Tutorial – Deep Dive on diagnosing VLOOKUP errors.
To download the workbook: https://www.mrexcel.com/youtube/_q0VdM1ES1g/
This is an advanced look at troubleshooting hard VLOOKUP errors. After using TRIM, CLEAN, and making sure there aren’t numbers stored as text, then I use this method to look at the ASCII code, character by character to figure out why the two values do not match.
But today, the vendor part number is reporting that a hyphen is ASCII CODE 63 instead of 45. What is up with this?
I had to modify my workflow to add UNICODE functions in order to discover that the Continue reading “Excel VLOOKUP Fails At Strange Hyphen – 2600”
Is your tooltip going off the page of your Power BI report? Maybe it looks weird on an iPad or smaller device. Adam shows how the new tooltip auto-scale feature can help.
April 2023 Update reference
https://powerbi.microsoft.com/blog/power-bi-april-2023-feature-summary/#post-23001-_Toc1599845071
Documentation:
https://learn.microsoft.com/power-bi/create-reports/desktop-custom-tooltips?tabs=powerbi-desktop#allow-tooltips-to-auto-scale-preview
📢 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 “What does Tooltip Auto-scale actually do in your Power BI Report?”
Using the new On-Object editing in Power BI Desktop? Have you figured out how to enable drillthrough yet? Adam has and is here to show you the clicks!
Power BI April 2023 Feature Summary
https://powerbi.microsoft.com/blog/power-bi-april-2023-feature-summary/
On-object Interaction
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction
📢 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/
— <a Continue reading “Enabling Drillthrough with Power BI On-Object Editing”
If you are moving your on-premises SQL Servers to the cloud, and/or if you have a mix of Azure SQL, Managed Instance and on-prem, make sure you are licensing correctly with Azure Hybrid Benefits. Shashank shows us how!
Azure Hybrid Benefit
https://azure.microsoft.com/pricing/hybrid-benefit/
Azure Hybrid Benefit – Azure SQL Database & SQL Managed Instance
https://learn.microsoft.com/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal
Azure Hybrid Benefit for Windows Server
https://learn.microsoft.com/windows-server/get-started/azure-hybrid-benefit
📢 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: <a href=”https://guyinacu.be/courses” Continue reading “Are you using your licenses correctly? See where Azure Hybrid Benefits can help!”
Microsoft Excel Tutorial – Easiest Way to Create a Lambda function in Excel.
A new version of the Advanced Formula Environment from Excel Labs has been released. It has an amazing new functionality called Import from Grid.
There are many times where I will build a complicated Excel formula in sub-formulas. I finally combine all the sub-formulas into one mega-formula by scooping the subformulas out of the formula bar and pasting in to the final formula.
The new Advanced Formula Envionment, found in the Excel Labs add-in, offers to create a LAMBDA function from existing worksheet logic in the grid.
Table of Contents
(0:00) Continue reading “Excel Labs Creates A LAMBDA From Existing Worksheet Logic – Episode 2599”
Join us live as we recap Power BI and Azure Data announcements made at Microsoft Build – May 2023. With special guest, Stephanie Bruno, Jason Himmelstein and John White!
Microsoft Build: https://powerbi.microsoft.com/en-us/blog/microsoft-digital-event-may-24-25/
Connect with Stephanie Bruno
https://twitter.com/StephTBruno
https://www.linkedin.com/in/brunostephanie/
https://data-witches.com
Connect with Jason and John:
Twitter: https://twitter.com/jasehimm
Twitter: https://twitter.com/diverdown1964
Twitter: https://twitter.com/BIFocalShow
Website: https://bifocal.show/
📢 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: Continue reading “🔴 Microsoft Build – May 2023 Social Hour”
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 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
📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (May 20, 2023) (Member Chat 2nd Half)”
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 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
📢 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 8, 2023)”
