Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear Community,
I would like to ask you about possible options, best way to model the following idea:
Comparing lots of data for 2 versions , but each version could be selected individually. So far what I did was that I can compare actual data with selected version (PLAN or previous year, I did this with selectedvalue option, but now I want to develop this. I want to have the opportunity to compare not only actual data with selected version, but compare selected version with selected version, see example:
Version 1 to be selected: Actual, Plan
Version 2 to be selected: Plan, Previous year
Versions could be 2 separe slicers.
table example:
Can you advise how to do this?
Thank you in advance!
Evelin
Solved! Go to Solution.
Hi @Evelin_
Use two disconnected table slicers (no relationshiop to fact) and reference the columns from those in measures:
Please see the attached pbix.
Hi @Evelin_ ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
Hi @Evelin_ ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
You could create 2 tables for use in the slicers, e.g.
Slicer 1 = DISTINCT( 'Table'[Version] )
Slicer 2 = DISTINCT( 'Table'[Version] )
Do not create any relationships with these tables, just use them in the slicers.
The measure you would use for the comparison would depend on the way you want to compare them, but an example showing the simple difference between them could be
Comparison =
VAR Version1 =
CALCULATE (
SUM ( 'Table'[Volume] ),
TREATAS ( VALUES ( 'Slicer 1'[Version] ), 'Table'[Version] )
)
VAR Version2 =
CALCULATE (
SUM ( 'Table'[Volume] ),
TREATAS ( VALUES ( 'Slicer 2'[Version] ), 'Table'[Version] )
)
VAR Result = Version1 - Version2
RETURN
Result
Hi @Evelin_
Use two disconnected table slicers (no relationshiop to fact) and reference the columns from those in measures:
Please see the attached pbix.
Thank you for both solutions! They worked
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
62 | |
61 | |
52 | |
39 | |
23 |
User | Count |
---|---|
85 | |
58 | |
45 | |
43 | |
38 |