Matrix and Slicers

[strangerMike]

Sorry I thought I understood this from a previous post.

I have a matrix and four slicers that filter data shown in the Matrix.  However, I added another Matrix and the slicers do not seem to work for this matrix. What am I doing wrong? The new matrix is a different data set as the original matrix.

Thanks

[v-qiuyu-msft]

Hi @strangerMike,

From the images, it seems those four slicers have fields Property, Campaign, BeginMonth, Channel from the table 'View_EmailMetricsUnionNatural', and the second matrix visual contains fields MetricName, RatePercent from the another table 'View_EmailRatePercentages', right?

To make sure those four slicers can filter the second matrix visual, please check if there is a relationship between the table 'View_EmailMetricsUnionNatural' and table 'View_EmailRatePercentages'. See: Create and manage relationships in Power BI Desktop.

Also check if slicers set to filter second matrix. You can select the slicer visual, then enable Edit Interaction feature, check if the filter is enable in the matrix visual. See: Visualization interactions in a Power BI report.

Best Regards,
Qiuyun Yu

[strangerMike]

Thank you Qiuyun Yu,

Yes, each table contains a Property, Campaign, Channel and BeginMonth.  So I was hoping that the slicers would work both Matrix's.

When I try to Manage Table Relationships I get this error when trying to establish the first field for Property (or any of the other fields, channel or campaign or beginmonth:

Can't create a relationship between these two columns because one of the colums must have unique values?

If I change the Property slicer, the first matrix and the other slicers all filter accordingly. 

Perhaps it can't do this because the new matrix does not contain any kind of Sum function to make it unique?

The percent values are passed via the table (query) results, so I just want to display them.

Now, checking the interactions with the slicers. When I click on the first slicer, I see the filter funnel on the second matrix but it does not change anything when a new value is selected:

I am new to this. So i am feeling a little lost.  In our SAS analytics system, we had the ability to create a measure and figure percentages based on the values in the matrix. Like taking # of Bounces and divid that by # emails Sent to come up with a percentage and plug that right into the first matrix.  I can't seem to do this in Power BI, so I am attempting to create the second matrix that will predetermine the percentages and show them in their own matrix. 

So when I click Property, matrix two (with percentages) should match the Property in slicer. Then a user could click a Campaign and then matrix two would only show that campaign.  Can't see to get there. Thank you for helping with this.

[v-qiuyu-msft]

Hi @strangerMike,

As the error stated, Property columns in those two tables have duplicate values. To create a relationship, at least one table column which used to create relationships require only one instance of a particular value. See: Cardinality.

You can create a summarized table from the second table use Summarize() function below:

=Summarize('EmailRatePercentages', [Property])

Then create relationship like between EmailMetricsUnionNatural' and 'EmailRatePercentages' to this new table. If issue persists, please share your .pbix file with us if possible.

Best Regards,
Qiuyun Yu

[Seth_C_Bauer]

@strangerMike Are the two datasets related to one another? What does the relationship look like? It could be that you are going in a direction that isn't supported unless you enable bi-directional crossfiltering.

[strangerMike]

thanks Eno1978,

The two datasets views esentially come from the same source. 

The views are just to show data in an additional way where i have to calculate percentages in the new one

So the campaign or property, etc should relate to each matrix. 

So if I choose a specific campaign,  I would like both Matrix's to filter using the same slicer. 

(the same with the other slicers).

How can I do this?   (I am very new to power bi).

Thanks