Slicer

[gerhigrabun]

Is there a way where i can have one company always showing and then use the slicer to choose other companies to compare to that one? Right now if im selecting a company on the slicer, it will only let me select that company, not multiple. I can either show one company or all of them.

[v-eqin-msft · Accepted solution]

Hi @gerhigrabun ,

Based on my test, you could create two tables for company selections, please follow below steps.

1. For the default company:

AlwaysSelectedCompany = VALUES('Table'[Company])

2. For all rest compies which are not selected:

ForAnotherCompany = VALUES('Table'[Company])

Apply the following formula to filter pane, set as "=1"

AllOtherCompies = IF(SELECTEDVALUE(AlwaysSelectedCompany[Company])<>MAX('OtherCompanies'[Company]),1)

3.Then create a measure:

Measure =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        'Table',
        'Table'[Company] = MAX ( 'AlwaysSelectedCompany'[Company] )
            || 'Table'[Company]
                IN ALLSELECTED ( OtherCompanies[Company] )
                    && ISFILTERED ( 'OtherCompanies'[Company] )
    )
)

The final output is shown below:

 Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.