Forum Discussion

MAruna's avatar
MAruna
Helper I
9 months ago
Solved

Filter Interaction

Hi team, Good day! I have 3 Filter Like year , Category, sub category  1) User needs to select all 3 filters then only they go with proceed option or else proceed option is grey out 2) once ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi MAruna ,

     

    Thank you for the update. I would like to clarify that the exact workflow you described (enabling/disabling the “Proceed” button, saving a “Lock this selection” state, and switching between Default View and Custom View automatically) is not supported natively in Power BI. Power BI cannot store checkbox states or programmatically change views based on slicer selections.

    As an alternative, you can try the below:

    • Use a DAX check (ISFILTERED) to show/hide visuals or a simulated Proceed button based on whether all slicers have values.
    • Use Personal Bookmarks to save a “Custom View,” and use the default/reset view as your “Default View.”
    • In Power BI Service, a user’s last slicer selections are automatically preserved until they reset them manually, which partially covers the “lock” concept.

    Hope this helps, please feel free to reach out for any further assistance.

     

    Thank you.

MAruna's avatar
MAruna
Helper I
9 months ago

Hi , thanks for your response.

 

Once we select year , category and subcategory then proceed and select the "lock thi section" option it will be custom view, once uncheck the "lock this selection " it will be default view how to do it.

 

Please find above attached snap.

 

Year    category       subcategory 

24-25.     All.               All.                    Default view 

 

After filter

24-25.        A.               B.         Proceed.     Lock this section.      Custom view

 

After Unlock

 

24 -25           A.               B.          Custom view       unlock.    Default view

 

 

Please suggest.

 

Thanks in advance.

nielsvdc's avatar
nielsvdc
Super User
9 months ago

I don't really understand what you mean and want to accomplish with the lock section option and default view. Do you want to change visuals or do you want to lock the filter selection?

 

Power BI doesn't support setting a checkbox and saving the setting for a user this way. Users can create personal bookmark, which can hold the applied filter settings for re-use.