Forum Discussion

mtibbert's avatar
mtibbert
Frequent Visitor
5 years ago
Solved

Exclude specific filter from visual interaction

I have two visuals. these are for Lead Time for manufacturing components.   The top right chart shows the average lead time for the final operation only broken up into 12 1-year rolling averages. T...
  • mtibbert's avatar
    5 years ago

    Found the solution, I need to have a slicer on APSort. This will filter down both visuals without their individual filters affecting eachother. I still cannot pick a point on the top chart like I wanted but it is better than nothing.

  • mtibbert's avatar
    5 years ago

    I have further refined the solution. I will now instead generate two data sets. One will have header level data showing the final operation only and the other will have item level data showing each operation. I will join the two in Power BI to link visuals.