Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Evelin_
Helper I
Helper I

Multiple version selection

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: 

Evelin__0-1743679572363.png

Can you advise how to do this? 

 

Thank you in advance! 

Evelin

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @Evelin_ 

 

Use two disconnected table slicers (no relationshiop to fact) and reference the columns from those in measures:

danextian_1-1743684016135.png

 

danextian_0-1743683972629.png

Please see the attached pbix.

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

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


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

5 REPLIES 5
v-kathullac
Community Support
Community Support

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.

johnt75
Super User
Super User

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
danextian
Super User
Super User

Hi @Evelin_ 

 

Use two disconnected table slicers (no relationshiop to fact) and reference the columns from those in measures:

danextian_1-1743684016135.png

 

danextian_0-1743683972629.png

Please see the attached pbix.

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

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


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Thank you for both solutions! They worked 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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