Forum Discussion

Lucy01's avatar
Lucy01
Icon for Helper II rankHelper II
17 days ago

Data Not Displaying When Selected

I have a month over month matrix that compares sales and I use a slicer to filter it by area, e.g London, Cardiff, Edinburgh. It was working perfectly to begin with, but after a recent refresh, it n...
Need Help
DreamITLearn's avatar
DreamITLearn
Icon for Advocate III rankAdvocate III
17 days ago

Hi Lucy01​,

this points to a text mismatch between the slicer value and the data model, not a relationships issue, since it only breaks for London specifically and filtering in Query Editor to "London" still works.

Most likely cause: there's a hidden character, trailing/leading space, or inconsistent casing in the "London" value coming from a different source than you think (e.g., your slicer field is pulling from a dimension/lookup table, while sales data has "London " or "london" with different formatting). The query editor filter works because it's filtering the raw column directly, but the slicer relies on the relationship between two tables matching exactly.

To fix:

  1. Check if your slicer field comes from a separate dimension table rather than the fact table itself, if so, compare the exact text value for London in both tables.
  2. Use TRIM() and CLEAN() in Power Query on both the slicer source column and the fact table's area column, then reload.
  3. If it's a direct text match issue, try LOWER() on both sides in Power Query to rule out casing differences.

This almost always comes down to the slicer's source values no longer exactly matching the fact table after a recent data refresh, even though both "look" like London to the eye.