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
HotChilli's avatar
HotChilli
Community Champion
6 years ago

We will need to see the relationships and are there any other tables?  

The date slicer filters both tables so that would imply a date table.  Is that right?

It's possible that the nature and direction of the relationships in the model don't allow the Currency table to filter the Bulking table.

  • artblakey's avatar
    artblakey
    Helper I
    6 years ago

    Hi HotChilli  and Anonymous 

     

    Thanks for your response.  I re-created the data on a new report, but I cannot figure out how to upload the PBIX file, or if I'm even allowed to upload the file.  Please let me know if I can do this to make things easier.  For now I will attach images:

     

    Yes, I am using a date table and the relationships are as below.  I have also attached the Desktop image with the bar chart and cards.  As I mentioned, the cards work well with a Slicer panel, but when I click on one of the individual currencies, the cards should change and they do not.

     

    Please let me know if I can provide any other information.

     

    Thanks.

     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi artblakey ,

      You can upload your pbix file to OneDrive for Business and share the link with us. Or you can provide some sample data in these three tables. Thank you.

      Best Regards

      Rena