Forum Discussion
Filter issues
Community Championjoohyo - without knowing too much about the data in your tables, it would seem to me those two tables should be one table.
If they came in through Get Data, rather than loading those two tables, create an Append Query in the Query window to merge the two tables into one, then uncheck "Enable Load" on the two source tables.
I am assuming the two tables are identical data but two different months of it (January sales, February sales) for example.
That will eliminate your issue of crossfiltering.
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.
- edhans
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?
