Difference between two sliced visuals, displayed as a visual

[FloK]

Hi all,

I have tried finding the solution to my problem for a while now, but simply can't figure out a way. Finally decided that the only way forward is signing up here and ask for help.

The data looks roughly like this:

Product	Month	profit
apple	01-31-2023	1750
orange	01-31-2023	-4000
apple	02-28-2023	1500
orange	02-28-2023	-3900
apple	03-31-2023	1600
orange	03-31-2023	-2500
apple	04-30-2023	1100
orange	04-30-2023	500

I have created two visuals with a slicer each. The slicer is assigned to each visual using Format --> Edit interactions

Below this, there should be another visual that displays - in the same format - the difference between the two chosen months for each product.

E.g. for January 2023 vs. February 2023 that visual should display a bar of -250 for apple and +100 for orange.

Thanks a lot for your help!

[tamerj1 · Accepted solution]

Hi @FloK 

only if you have two date tables one for eeach slicer. 

[FloK]

Hi @tamerj1 

Thanks for the hint. I have now created two tables (table slicer 1 / table slicer 2) and assigned them to the two visuals.

Unfortunately I'm still having trouble displaying the difference. I have set up the following measure:

Difference3 = 
VAR SelectedMonth1 = SELECTEDVALUE('Table slicer 1'[Date])
VAR SelectedMonth2 = SELECTEDVALUE('Table slicer 2'[Date])

return
    CALCULATE(SUM('Table slicer 1'[Value]),
    'Table slicer 1'[Date]=SelectedMonth1
    ) -

    CALCULATE(SUM('Table slicer 2'[Value]),
    'Table slicer 2'[Date]=SelectedMonth2
    )

And displayed it as a stacked column chart:

The third visual displays the same values as the first visual but not the difference.

Can you please help me adjust the the measure 'Difference3' (or the visual), so that it displays the actual difference?

Many thanks!!!

[tamerj1]

@FloK 

Not 100% like this but it should also work. Make sure interaction is active between all visuals 

[FloK]

It was indeed the interaction settings that prevented proper calculations 🙄