The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
86 | |
84 | |
35 | |
35 | |
35 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |