Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicer

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.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    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.