Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

exclude text value from table based on condition

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?

Need Help
Show and Tell
  • JoaoMarcelino's avatar
    JoaoMarcelino
    3 years ago

    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 🙂

1 Reply

  • JoaoMarcelino's avatar
    JoaoMarcelino
    Responsive Resident
    3 years ago

    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 🙂