Data Not Displaying When Selected

Hello,
I'm not completely sure of the exact cause, but this usually points to a data issue rather than a slicer bug.

The most likely culprit is a mismatch in the London value. Even if it looks identical, there could be a hidden difference like a trailing space, a case difference, or an extra character that Power BI treats as separate . Since the query editor filter works, the data is definitely there, but the slicer might be pointing to a different London entry.

What I'd try: in Power Query, clean the area column by trimming and removing extra spaces. Also check if there's a second London value hiding in the slicer, maybe under a blank or different formatting.

Another possibility is a relationship issue. If the relationship between the area dimension and the fact table is broken for that one value, the slicer would still show London but return nothing . Check the relationship settings and make sure it's active and the cross-filter direction is correct.

As a quick diagnostic, create a simple table visual showing the area name and a count of fact rows, then filter to London. If the count is zero, you've confirmed it's a matching problem.

Best regards,

Daniele