Forum Discussion

fergug's avatar
fergug
New Member
3 years ago

Crossfiltering between visualisations not working for some rows

Hello hivemind   I have two table visualisation (vis1 and vis2) vis 1 contains variables from a dataset formed by the merge of two datasets in power query, in which a single column is added to a l...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

Hello fergug,

 

If clicking on certain rows in vis1 doesn't cross-filter vis2 and the issue is resolved when removing the column added during the merge in Power Query, there might be an issue with the data in that column. Here are a few suggestions:

 

  1. Check for any discrepancies or inconsistencies in the data within the column that was added during the merge. Look for any differences or unexpected values that might be causing the cross-filtering issue. Ensure that the data type and format of the column align with the shared variable 'referral id' in vis2.

  2. Check if there are any null or blank values in the column added during the merge. These values might be causing the cross-filtering problem.

  3. Verify that the data types of the shared variable 'referral id' in both vis1 and vis2 are the same. If the data types don't match, the cross-filtering may not work as expected.

  4. Check if there are any column name clashes between the merged column and other columns in the dataset. If there are duplicate column names, it could lead to confusion and unexpected behavior.

  5. Ensure that the relationships between the tables used in vis1 and vis2 are properly defined in the Power BI data model. Confirm that the relationship between the shared variable 'referral id' is correctly established between the two tables.

Should you require further details or assistance please do not hesitate to reach out to me.