Forum Discussion
Display Selected and not selected values
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.
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