Multiple version selection

[Evelin_]

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

[v-kathullac]

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.

[v-kathullac]

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]

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 · Accepted 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.

[Evelin_]

Thank you for both solutions! They worked