Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Slicer object not effective on table

I am experiencing a strange issue. As you can see from the picture below, I created a slicer to filter out content based on the value of TweetID. It works on the other visual objects in the page, but it does not work on the table object where I am displaying the very same column on which I am filtering!

 

 

As you can see, I selected a single value in the slicer, the table should be filtered (it says that the slicer is affecting the visual) by showing the only row containing the selected ID (all TweetIDs are unique) but the table keeps showing all the TweetIDs. This is driving me crazy, because I am sure it is a very basic feature that I am missing (I am completely new to Power Bi). My original intention was to use the table as a filter: by selecting a TweetID, all the other visuals should have changed. It did not work and I arrived to this result while trying to debugging it: the table seems to be unaffected by filters (and, in turn, does not work as a filter on the other visuals).

 

I am sure the relationships in the data model are correct and, in this case, we are talking about the very same table so no relationship should be involved.

 

I appreciate any help.

 

6 Replies

  • Anonymous 

    That is odd.  Is there any chance you can share your .pbix file?  (load it to OneDrive or DropBox and share the link here).

    • Anonymous's avatar
      Anonymous
      Not applicable

      jdbuchanan71 

       

      Unfortunately I can't, there is plenty of Company-owned data in there. Is there any information I could give you to help you solve the issue? I am not really sure how to reproduce the problem with mock-up data. 

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User

        Can you start with a new .pbix and hook it to the same data source, see if you get the same behavior?  I was not able to reproduce the behavior you are seeing in a test file.

        It is behaving like the TweetID fields in the table and the slicer are not from the same table.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous 

    Could you check as i listed below?

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.