Forum Discussion

Titch79's avatar
Titch79
Frequent Visitor
9 years ago

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...
Need Help
opticshrew's avatar
opticshrew
Resolver II
9 years ago

Hi there,

 

Do you have any slicers or filters that could be effecting this data?

 

If you load the field seperately do you have a list of those values?

 

Thanks,

J

Titch79's avatar
Titch79
Frequent Visitor
9 years ago

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.

  • opticshrew's avatar
    opticshrew
    Resolver II
    9 years ago

    It might be worth creating a new table (Purely for testing) and add the column that the filter is based off. That way you'll be able to get a better understanding as to why that filter is causing the issue.

     

    From here you should be able to find out how to get your values to show.

     

    Thanks,

    J

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Titch79,

     

    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