Forum Discussion

Maddy_kumar's avatar
Maddy_kumar
New Member
3 months ago

Sales Trend visual not filtering by Location Mapping table

Hi community,
I am facing an issue where my Sales Trend chart does not respond to a Region slicer.
My Setup:
  • Fact Table: 'Sales Data' (Contains raw sales records).
  • Dimension Table: 'Correct Location' (Used for mapping because the original Sales Data regions were incorrect).
  • Measure Table: 'All Measure' (Contains my DAX measures like Total Sales).
  • Calendar Table: 'Custom_Calendar' (Connected to Sales Data).
The Relationship:
I have a Many to Many (*:*) relationship from 'Correct Location'[Region] to 'Sales Data'[Region]. The cross-filter direction is set to Single.
The Problem is - the values/lines in the chart remain unchanged (they show the total for all regions) regardless of the slicer selection.

1 Reply

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    3 months ago

    Instead of Sales Date (*) -> (*) Location_Mapping, change the relation direction to Location_Mapping(1) -> Sales Date (*)