I have a dashboard which includes 1 parameter and 3 filters that impact my reference line (average number of days). The graph I am trying to select an x-axis on is number of records v. number of days which has a reference line for average number of days.
Can I filter to a range on the x-axis for number of days without impacting the reference line? Essentially, I want to alter the view of the graph, but I don't want to exclude any of the underlying data. I've already tried a LOD expression to exclude the number of days variable and pulling that in as a reference line, but it hasn't worked.
Can you attach workbook with mock data?