Forum Discussion

JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago
Solved

Two Tables Different Data, Need common slicer filter

I have created a report with multiple tables. Table One will have spend and financial data Table Two will have metrics and performance data   In both case when I apply the common name to the slic...
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    Try changing the cross filtering on both and also check for any errors on the strings, sometiimes, Power BI identifies some values with spaces or additional characters, thus, considering it a different value. 

    Use the Trim, Clean features on Power Query and also try duplicating both key columns and deleting the older ones to see if that fixes the error. 

ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

Try changing the cross filtering on both and also check for any errors on the strings, sometiimes, Power BI identifies some values with spaces or additional characters, thus, considering it a different value. 

Use the Trim, Clean features on Power Query and also try duplicating both key columns and deleting the older ones to see if that fixes the error. 

JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago

Hi Ray,

Was travelling yesterday came back fresh to this, ran another trim and clean and this indeed has fixed the error, it is a very large data spanning back three years, 

Many thanks for your help

Thanks

Johnny