Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Suggestions For Getting Slicers To Work

I have two slicer controls, a multiselect (Fuel) and single select (Model).   If I select a value from the Model slicer, then deselect a value from the Fuel slicer that contains the selected value ...
Need Help
Seanan's avatar
Seanan
Solution Supplier
4 years ago

Hi Anonymous 

I believe I have fixed the issue by deleting the current model slicer, copying and pasting the fuel slicer and then changing the value to the model column. This does include the "Select all" option, is this a problem?

Please find the PBIX file for testing here.

 

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for this. However, the second slicer needs to be a single-select, and when I change it back to single, I'm still able to deselect Electric when Mustang Mach-E selected (thus the problem still remains).

     

    • Seanan's avatar
      Seanan
      Solution Supplier
      4 years ago

      Hi Anonymous 

      Apologies, I've done some digging around and it seems like a lot of users have run into this issue and have not been able to find a solution.

      You can post this as an idea at: https://ideas.powerbi.com/ideas/

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Is there anything else I could try? I've tried some of the third-party slicers, including the hierarchical ones but found nothing to fix this. There is actually a slicer control that has default options you can set but this slicer just doesn't work with my report.