Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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!
@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 !!
Measure 1:
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 😞
@nghyn , You need to follow this approach
Power BI Abstract Thesis: How to use two Date/Period slicers
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |