Issue with the slicers

[bhanuv]

Hi,

I have a slicer for Plant Names and Fiscal Period with the "Select All" option enabled. However, when I hover over a plant name, it replaces "Select All" with that plant name instead of keeping "Select All."

This issue occurs across all dashboards in Power BI Service, but it works fine in Power BI Desktop.

Has anyone faced this issue before? How can I fix it?

Thanks in advance!

[Cookistador · Accepted solution]

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)

[v-menakakota]

Hi @bhanuv ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota]

Hi @bhanuv ,

Could you please provide more details or a screenshot of the issue where "Select All" gets replaced by the plant name? This will help us better understand the problem and provide more precise assistance.

Thank you.

[Cookistador · Accepted solution]

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)

[Suresh604]

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:

1. Open your report in Power BI Desktop .
2. Select the slicer and go to the Format pane .
3. 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.
     
     

[bhanuv]

Hi Suresh,

I followed the steps you suggested, but the issue still persists. Could you please provide further guidance or suggest any alternative solutions? Any additional insights would be appreciated.

Looking forward to your response.

Best regards,
Vutchula Bhanu

[v-menakakota]

Hi @bhanuv 

Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster. 

If we don’t hear back, we’ll go ahead and close this thread.Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you

[v-menakakota]

Hi @bhanuv ,

I wanted to check if you had the opportunity to review the information provided by @Suresh604 . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you and Regards,
Menaka Kota.

[v-menakakota]

Hi  @bhanuv ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[Suresh604 · Accepted solution]

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!