The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
i use the table chart. It shows the article number and the price. The first row in this chart is a row full of null values.
I can't find the reason why.
Does anyone have an idea why?
You could try going back to your query and try adding the step, "Remove blank rows". It is in the Reduce Rows section, Remove Rows | Remove Blank Rows. If that doesn't work, you could also try adding a "Remove Errors" step in the same area.
If your fact table (many side of the relationship) has any rows that do not exist in your dimension (one side of the relationship), there will be an implicit extra row added to your dimension that is made up of all Blank values.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |