Graph filtering incorrectly

[FatBlackCat30]

hello all,

I have two visuals, one table and one line chart. 

The table has a list of companys and their respective sales numbers. This visual has a visual level filter that is only showing todays sales. 

the problem I am facing is when I click/highlight on a company in the table visual the line chart is only showing todays sales. I want the line chart to show the trending sales over time when I click on a company in the table

is this possible?

thank you!!

[VasTg]

@FatBlackCat30 

If I understand your ask correctly, you want to show one day(today) sales in the line graph when you don't click/select anything on the table. But you want to override the visual filter to show trend for selected company?

You could try something with below.

IF(HASONEVALUE('Calendar'[MONTH]),TRUE(),FALSE())

Replace month with company, YTD/tread measure in TRUE() and today's measure in FALSE.

If this helps, mark it as a solution.

Kudos are nice too.

[FatBlackCat30]

@VasTg  thank you for the input.

[VasTg · Accepted solution]

@FatBlackCat30 

When you choose/select a row in the table visual, it will pass the month filter along with company and other attributes to your graph.That caused your trend graph to only show today's data. Please follow the below instructions to achieve what you need.

Sample Input:

Create a month table as

Table1 = ALL(TABLE[MONTH])

Define the relationship between two tables (1 to Many)

Create a new measure in table 1

Measure 1 = CALCULATE(SUM('Table'[Value]),ALL('Table'[Month]))

Create the trend graph with month from table2 and Measure 1

See the screenshot for expected output.

The below image has a table visual filtered for jan, but both the graphs shows the same results.

After selection/click in the table, the right side graphs shows what you need- Ignoring the month but slicing by category.

If this helps, mark it as a solution. 

Kudos are nice too.