Category: Power BI

How To Do Text Analysis Using Python To Identify Parts Of Speech In Texts In Power BI

Posted on by Annie D

In this video, Gaelim is going to demonstrate how to do text analysis using Python to identify parts of speech in texts brought into Power BI

***** Video Details *****
00:00 Introduction
01:15 Source data
01:59 Filtered rows
02:20 Code
08:16 Data

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Continue reading “How To Do Text Analysis Using Python To Identify Parts Of Speech In Texts In Power BI” →

Harvest Power BI Slicer Selections To Use With Other Measures — Advanced DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam show how to write an advanced DAX formula to harvest (capture) a selection made within a slicer visual then integrate that back into other measure calculations.

***** Video Details *****
00:00 Introduction
00:28 Data Set
01:07 Adding Percentage Change To The Total Sales Table
02:49 Turning Percentage Change Table Into A Slicer
04:20 Fixing An Error Resulting From Lack Of Selection
05:44 Creating Total Scenario Sales Measure
06:19 Clicking Different Selections In the Slicer To Get Corresponding Results
06:36 Other Uses For Harvesting Slicer Selections

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE Continue reading “Harvest Power BI Slicer Selections To Use With Other Measures — Advanced DAX [2022 Update]” →

How To Automatically Remove All Empty Columns In Power Query

Posted on by Annie D

In this video, Melissa demonstrates how you can automatically remove all empty columns from a table in Power Query. Melissa’s approach will involve the standard Table.Profile M library function and its additional aggregates parameter to add a non-empty count column.

***** Video Details *****
00:00 Introduction
00:12 Sample query
01:36 Data set
02:13 Select columns
04:08 Add non-empty count column
09:07 Custom function

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Continue reading “How To Automatically Remove All Empty Columns In Power Query” →

REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)

Posted on by Annie D

Prioritizing questions around 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 courses available to Continue reading “REPLAY Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)” →

How To Utilize Error Bars In Power BI To Visualize Uncertainty In Your Data

Posted on by Annie D

Error Bars help visualize any uncertainty present in your data. Uncertainty is an important aspect to data or any fields so it’s best not to shy away from it. In this tutorial, Federico shares a couple of tricks with the Error Bars and how you can use it specify upper and lower bounds to the values in your line chart and customize the way the uncertainty is visualized on your Power BI reports.

***** Video Details *****
00:00 Introduction
01:36 Format pane
01:55 Error Bars
03:43 Different applications of Error Bars

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “How To Utilize Error Bars In Power BI To Visualize Uncertainty In Your Data” →

Are you thinking about your tooltips in Power BI?

Posted on by Annie D

The base tooltips in Power BI are fine. But are you overusing them? Adding everything to them in your visuals? Adam gives you some things to think about with your tooltips!

Create tooltips based on report pages
https://docs.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

📢 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 href="https://guyinacube.com" Continue reading “Are you thinking about your tooltips in Power BI?” →

Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam demonstrates how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.

***** Video Details *****
00:24 Summing up revenue column
00:37 Total sales measure
01:46 Reviewing total sales information by date
02:34 Total sales last year
04:20 Difference between sales this year vs last year
05:42 Visualization of difference between sales this year vs last year

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX Continue reading “Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]” →

Automating your formatted tables in Power BI!

Posted on by Annie D

Wondering how you can take advantage of the Formatted Tables feature in Power BI and automate the output to email? Jason Himmelstein shows you how you can do this with Power Automate!

Connect with Jason:
https://twitter.com/jasehimm
https://www.linkedin.com/in/jasonhimmelstein/
https://bifocal.show/

Formatted Tables:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-formatted-table

Social hour at Power Platform Conference:
https://link.bifocal.show/socialhour

Power Platform Conference
https://powerplatformconf.com/

📢 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!
*******************

— Continue reading “Automating your formatted tables in Power BI!” →

The Each Expression In Power Query / M

Posted on by Annie D

In this video, Melissa takes a closer look at the each-expression in the Power Query / M Language. When you see “each”, the formula or expression after it will be applied to each item in a list or column. Learn how you can utilize each in your reports.

***** Video Details *****
00:00 Introduction
01:25 Source
01:32 FunctionExpression
01:55 FunctionExpression2
02:07 EachExpression
02:16 EachExpression2
02:26 AllRows

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE Continue reading “The Each Expression In Power Query / M” →

Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]

Posted on by Annie D

Sam demonstrates how to get financial year to date calculations in Power BI with DAX. A simple formula that can produce great insight fast.

***** Video Details *****
00:46 Creating Total Sales Table
02:00 Calculating Sales Year To Date
03:20 Changing Calculation To Sales Financial Year To Date
04:36 Creating A Visualisation For The Existing Calculation

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download Continue reading “Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]” →

🔴 Power BI tips from the Pros – LIVE (Sept 10, 2022) (Member Chat 2nd Half)

Posted on by Annie D

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 (Sept 10, 2022) (Member Chat 2nd Half)” →

Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!

Posted on by Annie D

We are at an exciting juncture with Enterprise DNA.

We’ve evolved and extended the features of our learning platform so extensively that we’ve come to a point where we feel like we need to start repositioning our digital platform for the future. Create some separation between what we’ve offered in the past and what we want to be as an empowerment platform and partner moving into the future.

Our new platform that we’re calling Enterprise DNA On-demand is proving to be quite the game-changer, where you get to learn Power BI and the rest of the Power Platform on-demand. Watch as Sam gives a Continue reading “Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!” →