I have two separate data sources, one with financial data and the other with textual data. Each have an ID number that ties them together and I’ve connected them in my data model via the ID number. However, I’m filtering the data on my page by Account Name from the textual data source, of course the financial data doesn’t have the Account Name just the ID, which is not associated with the Account Names.
Is there a way in my visual table to only show the items where the ID is present in both data sources?
Thanks for any help.