cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gustavo98
Helper IV
Helper IV

Slicer -10 to 10 but not considering 0

Hi everyone,

 

Is posible to filter by a slicer values from -10 to 10 but not considering cero values?

 

 

 

 

1 ACCEPTED SOLUTION
v-polly-msft
Community Support
Community Support

Hi @Gustavo98 ,

Please modify the measure.

Measure Filter =
Var MinValue = MINX(ALL(TABLE),TablitaSlicer[Value])
Var MaxValue = MAXX(ALL(TABLE),TablitaSlicer[Value])
Var CurrentVal = [Elasticidad]
RETURN
IF(CurrentVal>=MinValue && CurrentVal<=MaxValue && CurrentVal<>0 ,1,0)

 

If I have misunderstood your meaning, please provide more details about your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-polly-msft
Community Support
Community Support

Hi @Gustavo98 ,

Please modify the measure.

Measure Filter =
Var MinValue = MINX(ALL(TABLE),TablitaSlicer[Value])
Var MaxValue = MAXX(ALL(TABLE),TablitaSlicer[Value])
Var CurrentVal = [Elasticidad]
RETURN
IF(CurrentVal>=MinValue && CurrentVal<=MaxValue && CurrentVal<>0 ,1,0)

 

If I have misunderstood your meaning, please provide more details about your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Gustavo98 , Create a table without 0 and try that as a filter

 

filter(generateseries(-10,10,1),[value]<>0)

The last step i need is use my measure "Measure filter" to only show value 1 in my table, but i think slicer has priority over that condition and for that reason, although im trying to use Measure filter equials to 1 in objects filter pane my result had not been succesfull.

Gustavo98_0-1660313428926.png

 

when i let know the filter which measure im using to filter? 

 

Gustavo98_0-1660312815448.png

Slicer is showing me 10>Elasticidad>-10.

 

For trying to exclude zero values in Elasticidad i create another measure called Measure filter:

 

Measure Filter =
Var MinValue = MIN(TablitaSlicer[Value])
Var MaxValue = MAX(TablitaSlicer[Value])
Var CurrentVal = [Elasticidad]
RETURN
IF(CurrentVal>=MinValue && CurrentVal<=MaxValue && CurrentVal<>0 ,1,0)
 
TablitaSlicer is a calculated table with values from -10 to 10 excluding zero:
Gustavo98_1-1660312991026.png

 

Im going to try this. ty for your answer.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors