Setting Default Value of Slicer Checkbox based on column

[adalton5683]

I have multiple Spreadsheets that are implementation trackers and we have multiple plants that must be completed. I am designing a simple dash that pulls all of our plants and if they are complete or not and then shows the percentage of the whole. 

I need to know how to make the checkbox default to checked or not checked based on the contents of a cell. like if said Plant has the Completion cell value of 'Yes' then check the slicer byu default. i saw the other date example and the slider example but i can figure out how to just set it based on the cell. 

Any help would be appricieated.

Thank You

-A

[v-yuta-msft · Accepted solution]

@adalton5683 ,

This can not be achieved directly in slicer visual. You may refer to the workaround mentioned in this thread.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.