Visual based on values of other visuals with filters

[bo_afk]

I have two charts on a page and each relate to separate filters. The aim was to be able to select any two dates (in the filter) and see side-by-side how the figures compare for each of these dates .

I now want to add another visual which shows the difference between these two charts.

E.g. I've filtered one chart for 5th Jan 2019 and it shows 150. 

I've filtered the other chart for 6th Jan 2019 and it shows 175.
I'd like a third visual to then show a difference of 25.

Is this possible?

[v-shex-msft]

Hi @bo_afk 

How did you filter on these visuals? Can you please provide more detail information to help us clarify this?
If these filters on based on same datasource filed, it is impossible to extract different selection from slicers.

Regards,

Xiaoxin Sheng

[bo_afk]

Hi @v-shex-msft ,

The visuals are filtered by slicers and from the same datasource. I used the 'Edit interactions' function to disable the slicers filtering the other visual.

So each slicer only affects the selection on one visual and not the other.

[v-shex-msft · Accepted solution]

HI @bo_afk ,

Dax formula can to get different value from these slicers, but these values can only used in its row contents, when you try to compare them, they will get same values of one slicer.

Please create a slicer with unrelated new data source fields, then you can write formula to extract selected value from different source of slicers.
Regards,

Xiaoxin Sheng

[bo_afk]

Hi @v-shex-msft 

Thanks for your response.

Yes, this is what I ended up doing. I made a direct copy of the dataset and then created a measure based on these two separate datasets and it worked fine.