exclude text value from table based on condition

[Anonymous]

Hi,

              Need help to create the logic for report creation. Above status column value is taken from separte table.There is no relation between them.

My requirement is if i click on include,all values to be shown...if i click on exclude ,aa and bb values need to remove only cc row should be there.

Is it possible?

[JoaoMarcelino · Accepted solution]

Hi @Anonymous ,

This is not a perfect solution but it presents the data you want:
Create 2 calculated columns:

Include = 1

Exclude = 
if(
    'Table'[Values] = "cc",
    1,
    blank()
)

After, create a Field parameter with both columns:

Drag the parameter to a slicer and to the column field of your visual

By selecting exclude only the cc is marked as "1"

By selecting include all are marked as 1

Sample file attached:)

Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂