cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors