Create line charts for different categories of products in different dates

[Anonymous]

I'm given a table that shows different kinds of products under six months. Here is an example of the test data. I want to achieve a situation such that every time I click the specific item in my matrix, it will show the spending from January to July in a line chart or bar chart. I know I need to use Format - edit interactions - select the filter. But they are combined into one column, just like what I've attached below. My x axis is the product name, y axis is several items - Jan's spending, Feb's spending, Mar's spending...July's spending. 

The test data is like:

	Jan	Feb	Mar	Apr	May	Jun	July
Product A	110	0	100	0	55	80	77
Product B	120	0	101	0	56	81	78
Product C	130	68	102	0	57	82	79
Product D	0	69	103	11	58	83	80
Product E	140	70	0	12	59	84	0
Product F	150	71	0	13	60	85	0
Product G	160	72	0	14	61	86	2

Hope someone can help me out!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
To filter the other visuals by-product but ignore the month's filtering you need 2 moths/calender tables.
first for filtering the report + matrix
and second just for the related visual.

The model will look like this:

Then you can create 2 measures for matrix standard sum ( or other needed calculation)

sum_ = sum('Table'[Value])
NOTE: you should drag to the matrix month from the "months table"

And for related graph the measure will be :

graph_sum = CALCULATE([sum_],REMOVEFILTERS(Months[Month]))
Now you can create a graph with months from the months table :

Result :

and both of them reflecting by slicer from the filter table:

The pbix is attached

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

[Anonymous]

Hii,

I still don't quite understand the first part you said "

but ignore the month's filtering you need 2 moths/calender tables.
first for filtering the report + matrix
and second just for the related visual.

The model will look like this:"

How to achieve the attached picture you've provided. Do I need to import data?

Thank you so much!

[Ritaf1983]

Hi @Anonymous 
No, you can duplicate the date table from the power query, I provided Pbix, you can follow my steps.

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