Understanding and fixing blank values in Power BI

Have you ever wondered "why do I have blank values in my Power BI Report?" In this video Mitchell will show how to identify blank values in Power BI and then how to fix this issue by cleaning up your dimension tables using the Power Query Editor!
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
00:00 - Introduction
00:45 - Scenario of Blank Values
01:46 - Understanding Blank Values
02:14 - Analyzing Blank Values
03:20 - Primary Reason for Blanks
03:49 - Fixing Blanks at the Source
04:13 - Workaround: Power Query Editor
07:21 - Secondary Reason for Blanks
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZbin: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@CavanHaganInvesting]

These both make sense, and I appreciate it. I have an issue where my slicers sometimes have “blank” as an option, even though there is no data under the blank. I have a filter that removes any values which have no data from the list so it’s not an issue but I’d love to know why it’s happening in the first place.

[@IarukaSkYouk]

This channel is consistently one of the best teaching sources I've seen for multiple softwares!!! thank you so much sirs and maams

[@jimgleason4040]

You guys are top notch. Great video as always.

[@mohdabdullah1271]

Thanks

[@aleksanderstrommer7677]

Wondered this yesterday

[@PCduetto]

Very good as usual. Just one question, why the State column is duplicated in the Fact table? In my view it's not necessary and make the video more complicated. Maybe even a little bit confusing. 😁

[@michaelt312]

Is this data publicly available?

[@JB_Photog]

Probably thru CMS.