Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter where user enter value

 Hello everyone,   I want create filter where the user enter a value.  For exemple the user enter 7000 and only Machines where the 7000 > MIN and 7000 < MAX are return. (Check picture)   I don't...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    You could create a measure to filter the table visual. The what-if parameter is to be used in this measure.

    Filter Measure = IF([Trials Value]>SELECTEDVALUE(ChargesOnly[Min])&&[Trials Value]<SELECTEDVALUE(ChargesOnly[Max]),1,0)

     

    Drag the Filter Measure into your table visual's visual-level filter pane and set its value is 1. Then you will find the table visual filtered.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

You could create a measure to filter the table visual. The what-if parameter is to be used in this measure.

Filter Measure = IF([Trials Value]>SELECTEDVALUE(ChargesOnly[Min])&&[Trials Value]<SELECTEDVALUE(ChargesOnly[Max]),1,0)

 

Drag the Filter Measure into your table visual's visual-level filter pane and set its value is 1. Then you will find the table visual filtered.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.