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.

Mauro89's avatar
Mauro89
Super User
9 months ago

Hi Sandeepbabu1508,

 

if I got you right you want to have the same slicer on multiple pages but the selection from one page to other pages shall not always be the same. If so you can try to not sync the slicers on the pages where you not want to have the selection from other pages applied.
You can find the option in the "View" tab as "Sync slicers". There you can choose on which pages the slicer shall be synced or not.

 

Hope this solves you problem. If so feel free to mark the post as solution.

 

Best regards!

Sandeepbabu1508's avatar
Sandeepbabu1508
Helper I
9 months ago

 example attached .

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 attached snip

  • Mauro89's avatar
    Mauro89
    Super User
    9 months ago

    Hi Sandeepbabu1508,

     

    I feel like your textual description varies from the picture. In the picture in Chart 2 there is every filter value indipendent of the selection displayed. 

    If this is what you want, then just go for disabling the interaction between the filter and chart 2.

     

    If you want to have in chart 2 all unselected values from the slicer maybe a DAX measure like this can help by using the negation of the filter selection:
    Show Not Selected =
    IF(
    ISFILTERED('Sales'[Category]),
    NOT('Sales'[Category] IN VALUES('Sales'[Category])),
    TRUE
    )

    BR