Forum Discussion
Displaying Data from Multiple Datasets in One Matrix
I'm trying to display data from two different datasets in one Matrix. I understand that it's because there isn't a relationship present, but I don't seem to be able to create one successfully either...
I have a Page Filter on which is showing only Opportunities which have been created in the last 12 months. But the data I'm needing to show is the Enquiry Source of the Lead which which was qualified to create the Opportunities created in this period.
The values do show in other pages which don't have this specific Filter on.
Of course we can add data from different datasets in one matrix if the relationship is built between them. In your scenario, could you please provide us your dataset structure along with same sample data, if possible you can share your PBIX file, so that we can make further analysis.
Regards,
Charlie Liao