Forum Discussion

artblakey's avatar
artblakey
Helper I
6 years ago

Visual not filtering correctly

Hi friends,   Hope someone can assist me please.   I'm currently using three visuals in PowerBI: 1. A bar chart for different currencies and corresponding volume (eg. AUD, EUR. GBP etc.) 2. A c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi artblakey ,

Please create the relationship between Bulking and Currency table based on field "Currency".

Best Regards

Rena

artblakey's avatar
artblakey
Helper I
6 years ago

Hi Anonymous 

I created the relationship as suggested, but I'm still getting the same result.  I also have a Dates table (based on field "Date") so I'm not sure if this is affecting the result?  This is how the relationships are currently set up:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi artblakey ,

    Please active the relationship which be created between Bulking and Currency table based on Currency field and de-active or remove the left 2 relationships.

    Best Regards

    Rena

     

     

     

     

     

     

     

     

     

     

    • artblakey's avatar
      artblakey
      Helper I
      6 years ago

      Hi Anonymous ,

       

      Thanks for the suggestion.  The problem is that I have other visualizations that use the relationship between the Currency table and Dates table (based on Date field).  If I remove this relationship then it throws off the other visualizations which run off a Year/Month Slicer.

       

      Is there a way to run both of these relationships at the same time (Dates/Currency and Bulking/Currency)?

       

      Thanks for your help on this.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi artblakey ,

        Could you please share your sample pbix file with me if it is convenient? Later I will check if there is any other method/workaround to achieve it base on your report file. You can upload it to OneDrive for Business and share the link with me. Thank you.

        Best Regards

        Rena