Compare Data from 2 Slicer in one Database

[nghyn]

Hi everyone,

I'm a newbie who recently started using PowerBI, so I don't have much experience yet. Currently, I'm facing an issue with comparing data within the same dataset. As shown in the first image, I need to separate two slicers corresponding to each set of charts:

• Slicer 1 -> Chart 1
• Slicer 2 -> Chart 2

Number 3 will display the comparison of data selected from the two corresponding slicers.

I've managed to separate them into two distinct slicers for each set of charts but haven't been able to integrate them into the comparison chart. I tried establishing a relationship from Slicer 1's data to the original data to display the comparison, but the numbers weren't correct.

Can someone please guide me on how to handle this data issue? Thank you very much!

[johnbasha33]

@nghyn  Try this approach

Create DAX Measures:

Create two measures, one for each set of charts, based on the selected slicers.
Let's call them "Measure 1" and "Measure 2".
These measures should filter the data based on the selections from their respective slicers.
Create a Comparison Measure:

Create a new measure to calculate the comparison between "Measure 1" and "Measure 2".
Use the FILTER function to apply the selections from both slicers to the original dataset.
Calculate the desired comparison between the filtered data sets.
Create the Comparison Chart:

Use the comparison measure created in step 2 to create a new chart.
This chart will display the comparison between the data selected from both slicers.

Measure 1 = CALCULATE(SUM('YourTable'[Value]), 'YourTable'[Category] = SELECTEDVALUE('Slicer1'[Category]))

Measure 2 = CALCULATE(SUM('YourTable'[Value]), 'YourTable'[Region] = SELECTEDVALUE('Slicer2'[Region]))

Comparison =
VAR Value1 = [Measure 1]
VAR Value2 = [Measure 2]
RETURN
Value1 - Value2

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Nothankyou]

Are slicers objects you can reference by name in DAX? How do you view and reference a slicer's name? 

[nghyn]

Measure 1: 

Customer_Site1 = CALCULATE(SUM(ALLDATA[CUSTOMER]),'Site Master'[STT])

Measure 2: 

Customer_Site2 = CALCULATE([Customer_Site1],USERELATIONSHIP(Calendar_Comparision[Date],ALLDATA[DATE]),USERELATIONSHIP(Site_Para_1[Name],ALLDATA[SITENAME]),REMOVEFILTERS('Calendar'),REMOVEFILTERS('Site Master'))

[nghyn]

Thank you, but I Want to show 2 Measure in 1 chart , example in my image 

I had separate them into two distinct slicers for each but in Chart the correct is just measure 1 and measure 2 is incorrect. This is my config in chart , is anything wrong in my chart , please help me 😞

[amitchandak]

@nghyn , You need to follow this approach

Power BI Abstract Thesis: How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg