Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Hanx
Frequent Visitor

Data Modelling and Filtering (Basic Tutorial/ Noob)

Context: A simple flat file (csv) from a youtube tutorial. I thought If I can apply the star schema , would it work or is it overkill?

Here is the schema

Hanx_0-1707292735890.png
When I make a simple matrix table to check, there is this 681K that is fixed regardless of any filters?

Hanx_2-1707292916228.png

The sum total (not shown) is correct but the 681K not being correctly summed to the locations



Im Making a Star Schema but when I apply filter, it shows Sum of Sales with Blank and with the Country.
How do I fix the Blank, is my model correct?

I have double checked in power query and removed all blank rows. Also since the order date was not continous, I made a calendar that has continous dates.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @Hanx ,

 

If your relationship tables contains records who can't correctly mapping to related table, it will show blank on Visual or slicer, this blank indicates the missing data.

vyangliumsft_0-1707358838745.png

 

This is the related document, you can view this content:

Solved: Blanks appearing in visuals - Microsoft Fabric Community

Solved: Seeing BLANKS in Slicer even though there are no B... - Microsoft Fabric Community

Solved: How to handle blank values in visuals - Microsoft Fabric Community

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi  @Hanx ,

 

If your relationship tables contains records who can't correctly mapping to related table, it will show blank on Visual or slicer, this blank indicates the missing data.

vyangliumsft_0-1707358838745.png

 

This is the related document, you can view this content:

Solved: Blanks appearing in visuals - Microsoft Fabric Community

Solved: Seeing BLANKS in Slicer even though there are no B... - Microsoft Fabric Community

Solved: How to handle blank values in visuals - Microsoft Fabric Community

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Hanx , Seem like there missing data in Dimesion Geography(Get all data) or there are null/blank keys in sales for GeoID. 

 

Once you remove that issue, it should work

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak Thank you for the quick reply

I have tried this with all of my tables in power query column by column via right click and then remove blank rows
Still the same

Is there any alternative way or any M query script that can be applied?

 

Hanx
Frequent Visitor

The Flatfile directly uploaded works well but not the star schema

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.