Forum Discussion
Page Filter when Column is False or Null (from a related table)
Yea I'm not sure if it's a direct query thing or what.
Let's take it from this angle. Using the same type of PBIX you uploaded, I'm getting the same behavior with manually entered data. Now, how would I get it to ONLY show records where there was a match and the flag was false? IE, I only want to see Jan 1 and June 4 data from the second table.
Community ChampionAnonymous
As mentioned it highly depends on how you have the data schema.
If you want to see these 2 dates then you need to add Bad Dates on a table object and on Filter select False.
If you add Job Dates and the filter will be False then you will also get the row with blank values.
That's because it is a many to one relationship from Dataset 2 to Dataset 1 and Dataset 2 is a master dataset.
I hope it makes sense.
I guess I'm not picking up what you're putting down. If I make a table visualization with the Bad Dates and Customers as the only two fields being used it shows the same thing (if you look at the total sum of customers) as if I had Job Date and customers.
Basically I don't understand this behavior. If I select "False" it filters on False (and includes Job Date records that are blank/don't have the match). if I select "True" it only shows trues. These seems like inconsistent behavior and doesn't make sense to me.
In my other file that uses direct query, selecting "False" shows only the false records, and selecting "True" shows only the true records, and there is no way that I can see to include the nulls / blanks that don't have matching records. If I go to Advanced filter method, I can enter to "Show items when the value is not True", but that only shows the False records and doesn't allow the Nulls / Blanks to show up.
So the behavior with direct query doesn't match the behavior with data entered directly, and neither method give me the ability to consistently handle the nulls.