cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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

1 ACCEPTED SOLUTION
Super User

Hi @FloK

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

4 REPLIES 4
Super User

Hi @FloK

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

Regular Visitor

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.

Many thanks!!!

Super User

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

Regular Visitor

It was indeed the interaction settings that prevented proper calculations 🙄

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors