Controlling interactive filtering across visuals

[ScottKC]

Hi champs,

My report contains:

- a Matrix visualization with "Departments" on the rows, "Months" (for last 12 months via Filter on the visual) on the columns, and "Sales" on the cells.

- a Table visualization listing "Customers" and "Sales" sorted by High to Low (with no time Filter on this visual).

With the normal interactions I can click on a "Department" in the Matrix and it interactively filters the Table to show the Customer Sales from that match. However, this is only showing Customer Sales that match thte Matrix and only where they're also within the last 12 months (as per the Filter on the Matrix).

Is there are a way to change the interaction, so that if I click on "Department" in the Matrix the Table will show Customer Sales within that Departmant based on all time sales and not just sales within the 12 months?

Hopefully that makes sense.

Cheers

[Ritaf1983 · Accepted solution]

Hi @ScottKC 
Yes, you need to create different dimension tables for this purpose + some dax manipulations.
Please refer to my answer in the linked post, including pbix to download :
https://community.fabric.microsoft.com/t5/Desktop/Create-line-charts-for-different-categories-of-pro...

For more specific suggestion 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If my answer was helpful please give me a Kudos and accept as a Solution.