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

20 Replies

  • Hasan's avatar
    Hasan
    Resolver I
    8 years ago

    do you have a relationship between those tables? if you dont that could be causing that issue

    • joohyo's avatar
      joohyo
      Frequent Visitor
      8 years ago

      Hello Dale,

       

      I am fairly new to PowerBi and do not know how to set up formulas or measures. Will that solve the issues? If so what needs to be done?

       

      Thanks,

       

      Joo

  • edhans's avatar
    edhans
    Community Champion
    8 years ago

    joohyo - 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.

    • joohyo's avatar
      joohyo
      Frequent Visitor
      8 years ago

      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's avatar
        edhans
        Community Champion
        8 years ago

        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.

    • 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    When viewing my report after I publish it, a random filter is activated. It's not locked so wondering why it's active. It's a problem becuase I'll have to tell everyone to clear that filter before reading the report. Help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Looks like it's working now! No filters are activated when publishing which is what I need.

       

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        Always do this Anonymous 

        1. Remove any/all filters as desired in the desktop before publishing, including closing the filter pane if it is open but not necessary. (takes up room)
        2. Publish
        3. Reset any filters in the service with this button
          2. If it is grayed out, that means nothing is set to clear, which is good.
        4. Then republish the app for the workspace.

        That should mean your end user has the report with no selections set.