Forum Discussion
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 attached snip
Having Requirement Summary below I have Provider slicer and I have these below pages:
Amount & Allowed by Provider
Treatments & Codes by Provider
Selected Providers
Not Selected Providers so When user selects providers in slicer:
Page 1 & 2 should filter based on selected providers
Selected providers should show only in Selected page
Unselected providers should show only in Not Selected page
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:
- Use Sync Slicers to keep the Provider selection common to Pages 1 and 2.
- Duplicate the Provider table as Providers_Display without any relationship.
- Add the following measure:
IsProviderSelected =
VAR ThisProv = SELECTEDVALUE(Providers_Display[Provider])
RETURN
IF( ThisProv IN VALUES(Providers[Provider]), 1, 0 )- On Page 3, filter visuals where IsProviderSelected = 1 (Selected Providers).
- 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.
8 Replies
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!
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
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
Displaying unselected values is fairly easy to do with measures, but if you want each provider to appear in its own row, you’ll need to use a disconnected table and a measure to control which rows are visible.
Unselected Actual Value = VAR _unselectedValues = EXCEPT ( VALUES ( Provider2[Provider Name] ), VALUES ( 'Table'[Provider Name] ) ) RETURN CALCULATE ( SUM ( 'Table'[Actual Value] ), TREATAS ( _unselectedValues, 'Table'[Provider Name] ) )Please see the attached pbix.
Is this provider slicer work in other pages like below when you do the provider slicer selection?
Amount & Allowed by Provider
Treatments & Codes by Provider
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:
- Use Sync Slicers to keep the Provider selection common to Pages 1 and 2.
- Duplicate the Provider table as Providers_Display without any relationship.
- Add the following measure:
IsProviderSelected =
VAR ThisProv = SELECTEDVALUE(Providers_Display[Provider])
RETURN
IF( ThisProv IN VALUES(Providers[Provider]), 1, 0 )- On Page 3, filter visuals where IsProviderSelected = 1 (Selected Providers).
- 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.
Hi Sandeepbabu1508,
We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you.Hi Sandeepbabu1508,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.
