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

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