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

How can I exclude data from a table using a filter?

 

How can I exclude data from a table using a filter?

Hi,

 

Please, I need some help.

 

I have a custom SPO list to manage company risks. This list has a calculated column that uses data from other columns to set a KPI: green (1), yellow (2), and red (0). By default, KPI is yellow (2). Now I need to display items only red KPI, everything else MUST be excluded. Users only want to see items that require their action/attention.

 

exclude.png

 

How can I do that? 

 

Thanks in advance.

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @efebo 

In the filter pane select your measure and and type Red

aj1973_1-1623533581400.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @efebo 

In the filter pane select your measure and and type Red

aj1973_1-1623533581400.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

efebo
Frequent Visitor

Thanks 😉

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.