Forum Discussion

Felisardo_78's avatar
Felisardo_78
Regular Visitor
4 years ago
Solved

Filter between values

Good Morning, Could you please help me? I have a table with several km where the train level passage is found. I need that in a filter, when entering a KM, it adds 3.1 (train size in KM) and segme...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Felisardo_78 ,

    Here are the steps you can follow：

    1. Create measure.

    selectvalue =
var _selectmin=
MINX(ALLSELECTED('Table'),[KM])
return
_selectmin +3.1
    Color =
IF(
    MAX('Table'[KM]) <=[selectvalue],"red","green")

    2. Select [km] – conditional fotmatting – background color.

     

    3. Enter the background color – km interface.

    Format style – Field value

    What field should we base this on – [Color]

    4. Result:

    If you need pbix, please click here.

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Felisardo_78 ,

Here are the steps you can follow：

1. Create measure.

selectvalue =
var _selectmin=
MINX(ALLSELECTED('Table'),[KM])
return
_selectmin +3.1
Color =
IF(
    MAX('Table'[KM]) <=[selectvalue],"red","green")

2. Select [km] – conditional fotmatting – background color.

 

3. Enter the background color – km interface.

Format style – Field value

What field should we base this on – [Color]

4. Result:

If you need pbix, please click here.

 

Best Regards,

Liu Yang

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

  • Felisardo_78's avatar
    Felisardo_78
    Regular Visitor
    4 years ago

    Good Morning!

     

    Thank you so much! 

    Worked perfectly!