Forum Discussion

Saltharion's avatar
Saltharion
New Member
3 years ago

Slicer affecting 2 charts differently

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 ...
Need Help
Saltharion's avatar
Saltharion
New Member
3 years ago

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's avatar
Fowmy
Icon for Super User rankSuper User
3 years ago

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's avatar
    Saltharion
    New Member
    3 years ago

    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))