Forum Discussion
Uniqueusername
Helper III
Helper IIIAdventure Works 2020 Model - blank dates DAX filter context
Hi all, I am trying to understand more about filter contexts in DAX. For this, I have downloaded the Adventure 2020 model from this link https://learn.microsoft.com/en-us/dax/dax-sample-model ...
Watch this Why is there a blank in my Power BI slicer??? - YouTube
As soon as you delete the two inactive relationships between date table and othe tables in model, blank row goes away. I am referring to the Adventureworks sample pbix file 2020.
UniqueusernameHelper III
Helper IIII found the culprit. The shipdatekey in the Sales table has blanks. I didn't know inactive relationships on columns with blanks can cause blanks to appear like that
- talespin
Solution Sage