Need Help On Slicer

Hi,
You cannot create a slicer with a measure. Slicers require calculated columns or tables. Create a calculated column with the same logic and use that for the slicer.

i created a calculated table and used it as slicer filter and maintain the measure on the comment to check if filter will be the same as the measure.

this is the dax i created as shown.

However the filter is not exactly matching with the measure comment as seen from the screenshots.  Am I doing something wrong? btw.. the percentage is a measure and not a calculated column...

For this screenshot, how can I add to my dax if the percentage is negative then comment is "???"

//tksnota

Hi Anonymous ,

Thanks for reaching out to our community.

Here's my workaround.

Since you can't put a measure into a slicer, you can create a table contains Comment_PO values as the slicer's field.

I created this table by entering data.

Create a measure as the visual level filter. Put the measure into the table visual filters and set up show items when the value is 1. The slicer is created from the Table (2).

Measure = IF(ISFILTERED('Table (2)'[Comment_PO Type]),IF([Comment_PO] in ALLSELECTED('Table (2)'[Comment_PO Type]),1),1)

Here's the result of the slicer filtering.

Best Regards,

Stephen Tao

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