Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Issue with the slicers

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 ...
Need Help
  • Cookistador's avatar
    Cookistador
    1 year ago

    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's avatar
    Suresh604
    1 year ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
v-menakakota
Community Support
1 year ago

Hi Anonymous 

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