Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cross filter on Scatter Plot affecting Line Plot

I have a store level scatter plot on left and total sales on right (line plot). 

Scatter plot has an additional filter that selects only the latest week

When a single item is selected on scatter plot, the line plot is filtered to that store, but it shows value for only one week. Whereas I need to show all weeks data on line plot for the selected store. 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You need to have a measure that uses all(Week[Week]) in the rend measure.

    But I doubt that can give you the desired result.

    Another way is you used an independent week/date table in scatter or line?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    How can i get the independent table to pick up store number from the scatter plot but ignore the week filter

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi  Anonymous ,

       

      Could you pls provide some sample data with expected output for test?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!