Passing filtered value to a disconnected table

[Anonymous]

Hi experts,

Need your help here.
I am using a disconnected table in the PBI model called "Count" in the report which has a continous column "Number" with values 1 to 5 million.This column is being used as axis in a Line graph to create a continuous line. As a value i am using a measure "Total calls where Total calls = Sum(Calls Fact[Calls])

We have another scatter plot visual, which looks like below and gets filtered based on a slicer "Caller type"

Now the requirement is based on the "Caller type" filter whatever max value we get as Number of callers in the Scatter chart X-axis, same value should be set in the Line graph as maximum value for X axis.

Basically we are trying to allign the scatter plot X-axis and Line graph axis. 

Thanks in advance.

[parry2k]

@Anonymous Not sure if I really understood your question. Can you provide an example with some data? Do you want to change the x-axis on the line chart based on the maximum value in the scatter chart? Not sure if this is what you are after?

[AllisonKennedy · Accepted solution]

@Anonymous If I understand correctly, I think you can create a measure: 

FilterDiff = MAX(CallFact[NumberCallers]) - MAX(Count[Number])

Then use this as a visual level filter on the line chart and set to FilterDiff is greater than or equal to zero.