Forum Discussion
Checkbox Slicer
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
4 Replies
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
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
