Forum Discussion

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
10 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.

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
10 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
Icon for Super User rankSuper User
10 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