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...
All of these answers refer to the expected behaviour of blank row being created by the semantic model in case where we have a key value on the fact table that is missing on the dim table. I understand that, it's the basic 'blank row' concept. But if that were the case, then I should see at least one row being counted for the blank value (see screenshot).
Conclusion: there is no missing value on the dim side...all is properly mapped? Do you agree.
Things get even more interesting: I just connected a blank PBI report to the same warehouse tables, imported them, and recreated the semantic model locally. And the blank row is no longer there. So this leads me to believe that the issue lies within the storage mode (direct lake on Onelake)?