cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NISHA_S
Resolver I
Resolver I

exclude text value from table based on condition

Screenshot 2022-12-26 154707.png

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?

1 ACCEPTED SOLUTION
JoaoMarcelino
Super User
Super User

Hi @NISHA_S ,

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:

JoaoMarcelino_2-1672056498785.png

 

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

JoaoMarcelino_1-1672056356403.png
By selecting exclude only the cc is marked as "1"

JoaoMarcelino_3-1672056631941.png

 

By selecting include all are marked as 1

JoaoMarcelino_4-1672056661574.png

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 🙂

View solution in original post

1 REPLY 1
JoaoMarcelino
Super User
Super User

Hi @NISHA_S ,

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:

JoaoMarcelino_2-1672056498785.png

 

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

JoaoMarcelino_1-1672056356403.png
By selecting exclude only the cc is marked as "1"

JoaoMarcelino_3-1672056631941.png

 

By selecting include all are marked as 1

JoaoMarcelino_4-1672056661574.png

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 🙂

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors