Forum Discussion

Sandeepbabu1508's avatar
Sandeepbabu1508
Helper I
9 months ago
Solved

Display Selected and not selected values

 When we select xxx value from provider slicer,the  selected provider  should display in all pages. And display selected providers in chart 1 and not selected values to chart 2 of page 4 like a...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    9 months ago

    Thankyou, Mauro89 and danextian for your responses.

    Hi Sandeepbabu1508,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on my understanding of the scenario, a Power BI slicer filters only the visuals to which it is connected, therefore, “not selected" values are not available automatically. This can be addressed by creating a disconnected copy of the provider table and a small DAX measure.

    Please follow the steps below, which should help resolve the issue:

    1. Use Sync Slicers to keep the Provider selection common to Pages 1 and 2.
    2. Duplicate the Provider table as Providers_Display without any relationship.
    3. Add the following measure:

    IsProviderSelected =
    VAR ThisProv = SELECTEDVALUE(Providers_Display[Provider])
    RETURN
    IF( ThisProv IN VALUES(Providers[Provider]), 1, 0 )

    1. On Page 3, filter visuals where IsProviderSelected = 1 (Selected Providers).
    2. On Page 4, filter visuals where IsProviderSelected = 0 (Not Selected Providers).

    Please find the attached screenshots and a sample .pbix file for your reference:


    We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

    Thank you.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
9 months ago

Thankyou, Mauro89 and danextian for your responses.

Hi Sandeepbabu1508,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Based on my understanding of the scenario, a Power BI slicer filters only the visuals to which it is connected, therefore, “not selected" values are not available automatically. This can be addressed by creating a disconnected copy of the provider table and a small DAX measure.

Please follow the steps below, which should help resolve the issue:

  1. Use Sync Slicers to keep the Provider selection common to Pages 1 and 2.
  2. Duplicate the Provider table as Providers_Display without any relationship.
  3. Add the following measure:

IsProviderSelected =
VAR ThisProv = SELECTEDVALUE(Providers_Display[Provider])
RETURN
IF( ThisProv IN VALUES(Providers[Provider]), 1, 0 )

  1. On Page 3, filter visuals where IsProviderSelected = 1 (Selected Providers).
  2. On Page 4, filter visuals where IsProviderSelected = 0 (Not Selected Providers).

Please find the attached screenshots and a sample .pbix file for your reference:


We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.