Category: Power BI

🔴 Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (April 20, 2024) (Member Chat 2nd Half)

Posted on by Annie D

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…

💥 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

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: <a Continue reading “🔴 Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (April 20, 2024) (Member Chat 2nd Half)” →

Wait?!? I can’t conditionally format a Line Chart in Power BI?

Posted on by Annie D

You have a requirement that your line chart needs to be conditionally formatted. But wait! There’s no option to do that within Power BI? Go to another tool? NOPE! Adam has you covered!

📢 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 Continue reading “Wait?!? I can’t conditionally format a Line Chart in Power BI?” →

Data Mentor Mastery: Tips & Tricks

Posted on by Annie D

Learn to use Data Mentor efficiently by creating queries, employing AI tools like formula generators and tools advisors, and organizing resources via folders and threads to boost learning and productivity.

Details of what you will learn during this video:

– Creating queries within Data Mentor to obtain on-demand assistance.
– Utilizing different AI tools including formula generators and tools advisors.
– Organizing and managing resources through folders and threads.
– Learning to customize queries for specific tasks and topics.
– Exploring follow-up prompts and additional functionalities for deeper learning and productivity enhancement within the platform.

***** Learning with Enterprise DNA *****
FREE Courses – rel=”nofollow”>https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

When Sorting Fails: Dynamic Formatting mistakes with Measures

Posted on by Annie D

Have a measure that you want to format as a string in Power BI? But then the sorting doesn’t work on it? What do you do? You can’t sort by column with Measures. Patrick shows you how you can leverage Dynamic Formatting!

Create dynamic format strings for measures
https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings

Zoe Douglas:
https://twitter.com/datazoepowerbi
https://www.linkedin.com/in/zoedouglas-data/

Phil Seamark:
https://twitter.com/PhilSeamark
https://www.linkedin.com/in/seamark/

📢 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 “When Sorting Fails: Dynamic Formatting mistakes with Measures” →

Meet Your On-Demand Mentor!

Posted on by Annie D

Explore how Data Mentor can guide and assist you

Details of what you will learn during this video:

– Understanding the personalized support and guidance provided by Data Mentor.
– Strategies for leveraging mentorship to navigate data analytics challenges.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Next Level Field Parameters

Posted on by Annie D

Explore next-level field parameters, delving into their intricacies, including understanding their differences from calculation groups, creating dynamic hierarchies, filtering models, and cycling through different combinations of fields within reports for enhanced visualization and user interaction.

Details of what you will learn during this video:

– Field parameters vs calculation groups
– Field parameters for simplicity, calculation groups for flexibility
– Using field parameters to switch between calculation groups
– Extending functionality with calculated columns
– Dynamic segmentation and filtering with field parameters
– Dynamic hierarchies and field cycling in reports
– Filtering measures based on field selections
– Advanced modeling for enhanced user experience

***** Learning with Enterprise DNA ***** Continue reading “Next Level Field Parameters” →

At last!!! Power Query within Power BI Report Builder!

Posted on by Annie D

With Power Query being available for Power BI Paginated reports in Report Builder, you can now do something that was very hard to do in the past. Patrick shows you what’s new!

Get data with Power Query available in Power BI Report Builder (Preview)
https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/

Connect to Snowflake, Databricks, and others with Power Query Online in Power BI Report Builder
https://learn.microsoft.com/power-bi/paginated-reports/report-builder/connect-snowflake-databricks-power-query-online

📢 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 #Paginated #GuyInACube

DAX Counterculture: Alternative Prospectives on DAX

Posted on by Annie D

Know the techniques in creating indexes and how to loop efficiently using DAX.

Details of what you will learn during this video:

– Showcase effective ways when and when not to use CALCULATE
– Determine when not to use Time Intelligence functions (always)
– Learn how to loop in DAX efficiently
– See how to use the greatly maligned EARLIER function
– Know the techniques in creating indexes in DAX

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – <a Continue reading “DAX Counterculture: Alternative Prospectives on DAX” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (April 6, 2024) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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

Connect with Brad Schacht:
https://twitter.com/bradleyschacht
rel=”nofollow”>https://www.linkedin.com/in/bradleyschacht/
https://bradleyschacht.com/

Connect with Scott Sewell:
https://twitter.com/scottsewell
https://www.youtube.com/@MSFT_ScottSewell
https://www.linkedin.com/in/mscottsewell/

📢 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 – https://guyinacube.com/tools/

#MicrosoftFabric #PowerBI #GuyInACube

Boost DAX Performance in Power BI with Dual Mode

Posted on by Annie D

Don’t ignore Dual Mode! If you are leveraging DirectQuery and Import in your Power BI semantic model, you could have some performance problems you aren’t aware of. Patrick shows you what’s going on!

📢 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 Continue reading “Boost DAX Performance in Power BI with Dual Mode” →

Wait!?! It’s the same data source! What’s going on???

Posted on by Annie D

Think you are using the same data source in Power BI? Maybe you aren’t? Patrick shows you how this can affect DAX Query performance and how to correct it.

📢 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 – <a href="https://guyinacube.com/tools/" Continue reading “Wait!?! It’s the same data source! What’s going on???” →

Create Beautiful Report Templates with PowerPoint

Posted on by Annie D

Build a minimalistic report in PBI with PowerPoint template and icons.

Details of what you will learn during this video:
– Learn basic tips & tricks to handle different shapes in PowerPoint. 
– Apply artistic effects to images to create glasmorphism style effects. 
– Use almost any background image to create beautiful templates. 
– Build a minimalistic report in PBI with PowerPoint template and icons. 
– Explore best custom theme generator to speed up Power BI development.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – <a Continue reading “Create Beautiful Report Templates with PowerPoint” →