Forum Discussion

joohyo's avatar
joohyo
Frequent Visitor
8 years ago

Filter issues

Hello, I have two dates with data. Whenever I filter by one month it still shows as the total of all the months on the cards and other visuals. Is there a way to fix this issue? Thanks.  
Need Help
Tips and Tricks
Tutorial Requests
joohyo's avatar
joohyo
Frequent Visitor
8 years ago

Bump

  • edhans's avatar
    edhans
    Community Champion
    8 years ago

    I'd love to help further, but cannot based on your description or without a sample file. 

    • joohyo's avatar
      joohyo
      Frequent Visitor
      8 years ago

      edhans where can I attach my file for you to take a look at?

      • RMDNA's avatar
        RMDNA
        Solution Sage
        8 years ago

        joohyo,

         

        Upload the PBIX to Dropbox or OneDrive and provide us with the link.

    • joohyo's avatar
      joohyo
      Frequent Visitor
      8 years ago

       

      In photo 1 you can see if i click a certain bar on the bar graph it filters by that individual organization as with the other visuals for a certain date in this case January.

       

      In photo 2 you can see if I dont click a certain bar (selects all organization) it only filters the bar graph by January date, but the other visuals are still showing both Jan. and Feb when I just want it to show the sum of all organizations for just the Jan data. As you see in photo 3 it shows when I select both dates it shows the same amount of numbers for other visuals from photo 2 

       

      RMDNA edhans

      • edhans's avatar
        edhans
        Community Champion
        8 years ago

        I still think you are using the two tables, which you should not. Unload the February table if, like you say, the Jan and Feb data are in the January data.