topic Re: Difference between two sliced visuals, displayed as a visual in DAX Commands and Tips

Difference between two sliced visuals, displayed as a visual

FloK — Mon, 22 May 2023 14:24:40 GMT

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!

Re: Difference between two sliced visuals, displayed as a visual

tamerj1 — Mon, 22 May 2023 16:43:16 GMT

Hi FloK

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

Re: Difference between two sliced visuals, displayed as a visual

FloK — Tue, 23 May 2023 07:17:01 GMT

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!!!

Re: Difference between two sliced visuals, displayed as a visual

tamerj1 — Tue, 23 May 2023 17:34:28 GMT

FloK

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

Re: Difference between two sliced visuals, displayed as a visual

FloK — Wed, 24 May 2023 06:28:32 GMT

It was indeed the interaction settings that prevented proper calculations 🙄