Chiclet Filter randomly not filtering report

[jcs93]

I have been using the Chiclet Slicer almost exclusively in reporting.  I occasionally get told by a user that the filter selection 'doesn't take' and I can't reproduce it.  It really hadn't been a huge issue until today when we had a payment made off data created within the report that was off because a filter selection didn't 'take'.

Is this an issue with the Chiclet itself?  The columns being used for filtering this specific report do not have any blank or null values and relate back to a main table with a strong relationship column.

The issue is so sporadic and random that I can't replicate, nor can I troubleshoot.

[Anonymous]

Hi @jcs93 ,

Not sure if you can find post in Issues forum:
https://community.powerbi.com/t5/Issues/idb-p/Issues

Maybe you can try using SELECTEDVALUE() or VALUES() function to to capture the values in slicer?

Best Regards,

Jay

[GilbertQ]

Hi there

What happens if you put in a measure into the values column in the Chiclet slicer? This is to ensure that it will only show slicers that have data?