Forum Discussion
Filter issues
edhans Hello,
What I did was I had a January table and then used the get data I have imported the February table. Then I used the appended function to insert the February data into the January table. Each time I filter just by January (or just february) it filters properly on just one client, but does not filter as the total of the entire client.
If the January table has Jan+Feb data, then you don't need the Feb table to be checked for "enable load"
What might be happening is your feb data in the visuals is being pulled from the Feb table and that will cause the issue you are seeing, as those tables aren't related, and really cannot be related.
I'd back up your PBIX file just in case because this could trash some of your visuals, but back it up, then go to the queries and uncheck "enable load" for the Feb table and save that.
Now all of your data should be in the Jan table if you did the append, and crossfiltering should work.
Hello,
I have appended and combined the Jan and Feb data together. However, the visuals only filter by client on a certain date (ex. jan). However, when I do not select a client on the bar graph I would like to see the total of all clients for just January, but it is not filtering and showing the combined data of both Jan. and Feb.
Is there a solution to this?