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

4 Replies

  • 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

      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

        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?