Forum Discussion
Date filter not filtering values with the same data source
Hello everyone, I´m currently working with data from direct query on a report I've done in the past using only imported data.
Scenario description: I want to display a line chart with a value on the Y axis and the dates for each measure on the X axis, the only filter applied to all my elements is based on other column which contains a boolean value, so every element will only work if this value is True. I also have a Card which shows the sum of all the points, So far so good, when I press a point in the chart it should filter that sum to show only the value of that specific point in time but this isn't working, the moment I press any point in the chart the card goes to "Blank" value.
Ideas I tried:
I created 3 extra columns based on the date in this same table for: Year, Month and Day. I recreated the same line chart using the combination of this 3 columns and the values measured mentioned before, and with this chart the filtering does work, it even filters the oher chart (the one based on the original date column) but not in the other direction (the original chart does not filter neither the card or the chart based on the three calculated columns).
I also tested with a selector, using the original date column, but it also doesn't filter correctly, it doesn't even filter the original chart (which is using the exact same column for dates).
I attached captures but sadly cant't share the data source or the report since it's sensitive information.
Base state:
Filtered using the chart with calculated columns (workin correctly):
Filtered using the original chart (doesn't work):
Filtered using the selector (note that even tho I selected every value that appeared on the original charts this doesn't show any info, neither does the card):
I appreciate any ideas on how to solve this
3 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523As I said, the problem only appears with the direct query version, and I cannot share that version
I attached a link with the pbix file I made for testing with the same error. Note that this is the import mode only, in this version the filtering works correctly, but for some reason when I have the exact same data, from the exact same source, with the exact same visuals in direct query mode then the filtering doesn't work at all as previously mentioned, the only difference being the creation of this hierarchy which I'm not using (see the pbix) and the direct query version not accepting NULL values by default.
Any suggestions? I trully don't know if there's some obvious mistake I'm overlooking.
Sorry for the delay from previous answer, I had no way to share even this version since I couldn't acces any of the drive options.
https://drive.google.com/drive/folders/1CyuievXYJ8Vs7koToOC1R2brRUVRukdQ
