Issue with Filter

[Samhunt]

Hi everyone, 

I am facing an issue with a filter. So I am filtering this cluster column chart with 2 filters. 

First filter Current year offset, where I use value 0 meaning that only dates in the current year shall be used. 

The second filter Past/Present, where I mark in my calendar Lookup all the dates from Previous months as past. Dates from the current month are marked as future.  

When I go in query and apply filters in the above columns I get 244 values which are all the dates from January until the end of August. 

When I apply this filters in my graph I only get 182 values and this is because of the Past/Present filter. 

Please check video below. 

https://www.loom.com/share/f7d55f936dd045cfbfe45bb9fd7a4a7f?sid=1917e319-52d3-4941-9e1c-37e0fc9cecf3

Any ideas why this discrepancy?

Thank you very much for your time 🙂 

[Anonymous]

Hi @Samhunt ,

Your video shows that there are unsaved modifications in Power Query. You could try to click 'Close & Apply' to apply your latest Power Query changes and check if that resolves the issue.

Best Regards,

Bof

[Samhunt]

Hi @Anonymous that was not the problem, I saved anyway but I did not really change anything on the query. 

[Samhunt]

@Idrissshatila I updated the video with a new one, sorry for that 

[Idrissshatila]

@Samhunt , did you check the video you published ?

Subscribe to my youtube channel https://www.youtube.com/@PowerBISolution