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
artblakey's avatar
artblakey
Helper I
6 years ago

Hi HotChilli  and Anonymous ,

 

Thanks for the information.  I read the article and changed the cross filter direction between the Date and Currency table from Single to Both.  This did change the values in the Cards, but not really as expected.  I could not figure out how to share the file via OneDrive, but here is the sample data of the tables:

 

Bulking Table:

 

DateCurrencyGross VolNet VolCount
1/04/2020AUDUSD                 143,259.93                 142,439.251
3/04/2020AUDEUR                 111,351.11                 111,301.291
30/04/2020AUDUSD                 201,375.78                    96,021.721

 

Currency Table:

 

DateCurrencyVolume
1/04/2020AUDUSD                     23,819.65
1/04/2020AUDUSD                     12,711.68
1/04/2020AUDUSD                           410.34
1/04/2020AUDUSD                     43,228.76
1/04/2020AUDUSD                                0.36
1/04/2020AUDUSD                           138.22
1/04/2020AUDUSD                     10,272.25
1/04/2020AUDUSD                     52,678.67
1/04/2020AUDEUR                     45,059.40
1/04/2020AUDEUR                     38,674.01
3/04/2020AUDEUR                   107,396.14
3/04/2020AUDEUR                        3,930.06
30/04/2020AUDUSD                     66,612.06
30/04/2020AUDUSD                     52,677.03
30/04/2020AUDUSD                        4,862.65
30/04/2020AUDUSD                        6,748.07
30/04/2020AUDUSD                     40,170.37
30/04/2020AUDUSD                     29,950.85

 

When I click on AUDUSD in the bar chart, I get the correct result:

 

 

 

 

 

 

But when I click on AUDEUR, I get incorrect figures for some reason:

 

 

 

 

 

 

 

What I am expecting for AUDEUR is:

Gross: 111,351.11

Net: 111,301.29

 

Am I doing something wrong with the relationships?

 

Thanks in advance.

  • 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