Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter by WeekNumber & SelectedValue not working

Hi, I've searched a lot of other posts but I can't seem to solve my problem.   I have 2 main tables - Mobile & Web that record users of our apps.  There is a 3rd table called AuthActivations that ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

According to your description, this situation might be caused by lacking of relationship between two tables, And when using selectedvalue, it will force tables create a relationship.

These are just my guesses, otherwise, could you please share some example data or PBIX to me if you don't have any Confidential Information?

If so, please upload your files to One Drive and share the link here.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    thanks for your response.

    Below is a link to OneDrive with the .pibx files. Please let me know if its not accessible.

     

    Regarding the relationships: I have joined the necessary tables to be able to filter by BusinessId - 

    Auth0Users_Mobile & 
    Auth0Users_Web.
     
    the problematic columns are in the 'Weekly Activations' table: 
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      The pbix is not accessible, please make sure anyone with the link can edit it.

       

      Best Regards,

      Jay

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Jay, I've sent you a Private message regarding this. 
        Basically I can't make anything on our company's OneDrive public, but I can open it up to you via an email invitation.

        Could you send me your email please?

         

        thanks 

        Anne