Forum Discussion
Issue with the slicers
This issue is related to the button sclicer
This issue is known (many posts related to this issue)
My advice to fix it, would be to repalce it by Slicer ? (5th line on the screenshot I pasted)
Hey Bhanu! I found another solution that might help. Instead of relying on the default slicer behavior, you can create a measure that dynamically displays 'All Plants' when all values are selected.
SelectedPlants =
IF(
COUNTROWS(VALUES('Plant Table'[Plant Name])) = COUNTROWS(ALL('Plant Table'[Plant Name])),
"All Plants",
CONCATENATEX(VALUES('Plant Table'[Plant Name]), 'Plant Table'[Plant Name], ", ")
)
This way, even if the slicer replaces 'Select All' with a specific plant name, the card visual will still display 'All Plants' when everything is selected. Let me know if this works for you!
Hi Bhanu,
I wanted to share a potential cause for the issue you're experiencing with the slicer in Power BI Service. It seems that certain slicer settings might be contributing to the behavior where hovering over a plant name replaces the "Select All" option.
This might be the root cause, so can you please check the following:
- Open your report in Power BI Desktop .
- Select the slicer and go to the Format pane .
- Ensure the following settings are configured correctly:
- Selection Controls: Confirm that "Single Select" is disabled. If it’s enabled, it could cause the slicer to replace "Select All" with the hovered item.
- Select All Option: Make sure the "Select All" option is enabled in the slicer settings.