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
wasonj1
Frequent Visitor

How to create slicer with null and not null?

Hi,

I have an IP Address column where there are various IP values and nulls. I want to set up a slicer to show null or not null values, does anyone know how I can set that up? I have my slicer set up to show the null values, but not sure how to do a not null option. I do not want the slicer to show each individual IP address because then it is a huge list that is not useful. 

wasonj1_0-1620833615166.png

 

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @wasonj1 ,

 I am assuming that your IP Address column is TEXT type in Power BI.

 

You can create a calculated column using DAX something like this:

 

newSlicer = IF(yourtable[ColumnName] = "null", "null", "not null")

 

In the above DAX formula replace yourtable[ColumnName]  with your table name and column name that has IP address values.

 

Then use this newSlicer  column as a slicer.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

2 REPLIES 2
Pragati11
Super User
Super User

Hi @wasonj1 ,

 I am assuming that your IP Address column is TEXT type in Power BI.

 

You can create a calculated column using DAX something like this:

 

newSlicer = IF(yourtable[ColumnName] = "null", "null", "not null")

 

In the above DAX formula replace yourtable[ColumnName]  with your table name and column name that has IP address values.

 

Then use this newSlicer  column as a slicer.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

That did it perfectly! Thank you for your help!

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.