Slicer affecting 2 charts differently

[Saltharion]

I've got 2 charts, a Sankey chart and a clustered bar chart, showing tasks assigned to different teams. I've created a slicer that allows the user to filter by tasks due in the next week, the next 2 weeks and the month.

The slicer works correctly when I select next week & next month, but when selecting next 2 weeks there is a discrepancy between the charts - the Sankey correctly shows 1 task due, and the bar chart doesn't show anything. What could be causing this difference?

[Fowmy]

@Saltharion 

If it works for some selection and and not for others then you need to check the DAX logic that is implemented in your meaure and/or if you have applied Visual Level filters and how it affects.

[Saltharion]

If there is a problem with the measure, wouldn't it affect both charts? The charts are both based off the same data source

[Fowmy]

@Saltharion 

It depends how the filter context works in each of these visuals, check the categorical and value axis that are used in both, do you have any other fileds added in the bar chart or any visual level filter applied which affect the calculation?

[Saltharion]

The bar chart uses 'Dependency Owner' on the x axis and '#Dependencies' on the y axis, based on the sum of dependency IDs.

The Sankey chart uses 'Raised by' as the source, 'Dependency Owner' as the destination and the sum of dependency IDs as the weight.

My measure is:

Period_Selection = VAR Period_Selected = SELECTEDVALUE('Custom Period' [order])

VAR _week = MAX('Clean up' [Due Date]) IN FILTER(DIM_DATE[Due Date] >= TODAY() && DIM_DATE[Due Date] <=TODAY() + 7)

VAR _2week = MAX('Clean up' [Due Date]) IN FILTER(DIM_DATE[Due Date] >= TODAY() && DIM_DATE[Due Date] <=TODAY() + 14)

VAR _month = MAX('Clean up' [Due Date]) IN FILTER(DIM_DATE[Due Date] >= TODAY() && DIM_DATE[Due Date] <=TODAY() + 30)

VAR _all = MAX(DIM_DATE[Due Date]) IN ALL('Clean up'[Due Date])

RETURN

int(SWITCH(Period_Selected, 1, _week,

2, _2week,

3, _month,

4, _all))