Forum Discussion
Solved
Difference between two sliced visuals, displayed as a visual
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 ...
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!!!