Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
When I make a simple matrix table to check, there is this 681K that is fixed regardless of any filters?
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.
Solved! Go to Solution.
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.
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.
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.
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.
@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
@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?
The Flatfile directly uploaded works well but not the star schema
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |