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 o...
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 🙂

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 🙂