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!

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:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
#PragmaticWorks

Рекомендации по теме

Комментарии

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.

CavanHagan

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

IarukaSkYouk

I'm only two minutes in, but the caption image, the title, everything describes exactly where I'm at. I'm more impressed that you opened with exactly what my first visual looks like currently with blank barely out competing a top agent 😂

woofpuppy

Thank you. Good content and good delivery. What is the reference to the prequel video that you mention in this video?

markdhenderson

Thank you! I was struggling to find blanks and I was trying to figure out how to get the data to show me. When I saw you show the table behind the visual, I knew I had my key! I found the problem in the data in short order and was able to get this done for my client!

evelynlivant

I wish there was a love button for this video

usmanmb

You guys are top notch. Great video as always.

jimgleason

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. 😁

PCduetto

this video was long for no reason. ugh

freshios

Understanding and fixing blank values in Power BI

Understanding and fixing blank values in Power BI

Fix Blank Values in Power BI

Power BI Relationships Not Working? How to Fix 🛠️ Missing and Blank Values [Part 2]

How to fix Blank value in slicers in Power BI | Power BI for beginners

How To Fix Static Segmentation and Blank Row in DAX | Power BI

Microsoft excel is opening a blank screen# Fix# Easy way# Unhide sheet

Measures vs. calculated columns in DAX and Power BI

how to fix search empty box windows 11, 10 | Search Showing Blank Box | Fixed [6 Easy Ways]

Excel Blank Rows FIX! Fill Every Gap FAST - Simple Tutorial #excel #exceltips #datamanagement

Rain Bird Residential Valve Troubleshooting: Using the Bleed Screw to Fix a Sprinkler Leak

MapleStory Blank Error Message Fix (Use CC for more details)

How to Answer Any Question on a Test

Correcting Blank Character Accessibility Warnings

Windows 10 Search Showing ‘Blank Box’ Fix

Windows Start Search Blank FIX

The single biggest reason why start-ups succeed | Bill Gross | TED

Handling MULTIPLE fact tables in Power BI

PHP Shows a Blank White Screen: How to Fix it to Get Errors to Display #shorts

Empty Solutions: Why Quick Fixes Don’t Solve the Root Problem

How to Fix Blank/Missing Desktop Icons on Windows 10! | SCG

If () Function in Power Apps Blank Problem: Fix It In minutes! #29

12-fix empty values error

118. [FIX] Combo Box Empty Value Show in MS Access Bangla Tutorial | Ahsan Tech Tips

Identify, Fix & Remove Empty Spaces in DataFrame of #pandas