Forum Discussion
Solved
Table visual error
Hi, I'm frustrated when table visual error out. I have two fact tables, t actual, t budget. Dim tables are t actual appended with t budget, dim proj, dim award, dim task, dim cost center. They wor...
Hi Xfoster
I understand how frustrating this can be. To better understand what’s happening, could you please provide a bit more detail? This information will help identify whether the issue is related to ambiguous relationships, many-to-many joins, or filter direction.If that Vendor table is not one row per VendorKey, then it is not a true dimension table anymore. Once that happens, Power BI may still let the model load, but visuals can fail or return errors/incorrect results because the filter path is no longer deterministic. This aligns with the usual Power BI guidance to keep dimensions on the “1” side and facts on the “many” side, using single-direction filtering from dimension to fact.
