Checkbox Slicer

[Anonymous]

Hi!

I have a table with a "Count" column. Values are 0 and greater.

I would like to use a Checkbox Slicer "[x] Include Zeros" or something similar that would work.

1] When the Checkbox Slicer is checked "[x] Include Zeros" 

I would like to chage the table filter for the column "Count" to "Count >= 0"

2] When the Checkbox Slicer is un-checked "[ ] Include Zeros"

I would like to chage the table filter for the column "Count" to "Count >= 1" or "Count >= All"

Thanks

[v-danhe-msft]

Hi @Anonymous , 

It seemed wired for your logic:

for the column "Count" to "Count >= 0" and "Count" to "Count >= 1" or "Count >= All"

the data in [Count] column>=1 must >=0, so which one should the data show? And what is the logic of "Count>=All"?

Could you please offer a sample data and your desired result if possible?

Regards,

Daniel He

[Anonymous]

Hi!

Summary Table with Counts for each Item

Based on the picture above you can see that I have in the "Count" column rows with values from 0 to n. (> 0)

I would like a slicer that works like a checkbox (or a toggle button) , something like "[ ] Show only non-zero Items" with just two states.

1] "[ ] Show only non-zero Items" - If un-checked it shows all Items.

2] "[x] Show only non-zero Items" - If checked it shows only Items that have a Count > 0

(All the rows with "Status" = "green traffic light" would be filtered out)

Hope that makes it clear.

Thanks

[Anonymous]

@Anonymous did u find solution? if so can u share here

[Anonymous]

Hi!

No yet ! 😞