Forum Discussion
Blank value in button slicer
Hi all, I have a semantic model (storage mode direct lake on onelake) in Fabric. I have a pbi report connected to it. The model is as follows: dim_Customer fact_Contract fact_Invoice Custome...
cengizhanarslan
Super User
Super UserIt is called "Referential Integtrity", you have Primary Key fields in your fact table that are not available in your Dim table. Even if dim_Customer[B2B/B2C] has no blanks, Power BI will create a blank/unknown row on the dimension side when any fact row can’t be matched to a customer.
The best fix here would be correcting your Dim table, but if you cant you can enable the option below which would force the relationship work as INNER JOIN instead LEFT JOIN.