Forum Discussion
Matrix and Slicers
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.
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