Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.