Filter between values

[Felisardo_78]

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 segmentation in this table, listing the level crossings that are between these 3.1 KM.

In the example above I would choose the starting KM, add 3.1 and segment the table below into those KMs

[Anonymous · Accepted solution]

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]

Good Morning!

Thank you so much! 

Worked perfectly!