Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter not applying for different users on the same dataset

I was training users on Power BI last week. There were four of us all using the same data set under a shared workspace. 

We pulled Net Sales out into a card and it gave us a summation of Net Sales for the entire data set (as Expected).

When we went to filter by year (year to "Filters on this page"). Two of us were able to see sales filtered for the current year and the other two user were still seeing sales for the entire data set. I had them try to take it out and try again and they still had the same result.

They shared their screen with me so I was able to make sure they were doing it correctly.

I have had this happen before and I thought it was just a one time fluke so I didnt think anything of it. 

Our end users will not be able to trust the integrity of the information they are seeing. We would like to get this resolved before we do any more trainings. 

 

Thanks in advance for any insight on this.

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    Did you make sure that the relationships were in place between the tables?

    It sounds to me as if there was a relationship missing.

    I have never seen different data unless there is something different in the PBIX files.
  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ，

     

    I agree with what suggested by GilbertQ .Better check with the other 2 users to see whether the relationships and the direction in the relationship have seen set correctly.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the response v-kelly-msft  and GilbertQ !

       

      I would agree that relationships would be the first place to look but this was in the service where the data set had already been created.  As well, the users were using the same data set so it doesnt make sense that 2 users are able to use the filer and 2 users were not.

      Could it be something with specific users or version upgrades??

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        I would suggest talking to the dataset owner and making sure that it does have those required relationships?