Forum Discussion
Help modeling situation "sample"
Hi, Anonymous
According to your sample data and the expected result, I found that there occurs a little problem in your sample data. The value I circled should be “CONTOPSA”, right?
Then I created a One to many, Both filter on these two tables, like this:
And I created a Matrix and a Slicer and place them like this:
And I guess this is what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Anonymous
According to your sample data and the expected result, I found that there occurs a little problem in your sample data. The value I circled should be “CONTOPSA”, right?
Then I created a One to many, Both filter on these two tables, like this:
And I created a Matrix and a Slicer and place them like this:
And I guess this is what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.