I have a fact table which is joined to my date dimension by date. On my page I have a Month Name Short Filter and Year Filter. I have a number of visuals on the page table , bar graphs, stacked column chart using the month filter. At the top I have 3 line graphs, Showing MTD Actuals, YTD Actuals and Actuals for previous 12 months. Line graphs have MMM-YY Axis and interaction by month is disabled to display year graphs.
I would like the graph lines to stop based on month selected. Using the existing Slicer with out having to build separate slicers.
Look forward to your thoughts.