Forum Discussion
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 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
Hi Felisardo_78 ,
Here are the steps you can follow：
1. Create measure.
selectvalue = var _selectmin= MINX(ALLSELECTED('Table'),[KM]) return _selectmin +3.1Color = 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
2 Replies
Hi Felisardo_78 ,
Here are the steps you can follow：
1. Create measure.
selectvalue = var _selectmin= MINX(ALLSELECTED('Table'),[KM]) return _selectmin +3.1Color = 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
Good Morning!
Thank you so much!
Worked perfectly!
