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 IIItalespin
Thanks for that ! Removing the inactive relationships fixed it. But I don't know what is driving that behaviour. I also tried to check for dirty data like in the video you have linked to but couldn't find anything standing out
How would you avoid these blanks in a situation where you certainly require an inactive relationship ?
Thanks
- talespin
Solution Sage
hi Uniqueusername ,
In case its a data issue, you should include blanks.
Otherwise you can just apply filter from filter panel to exclude blanks.