"Between" slicer with paired values: Oxygen/Nitrogen

[Julia1234]

Good day! I am looking for a way to create a filter (ideally between slicer) to operate pair combinations of decimal numbers.
Table is like
Order   Oxigen Nitrogen  Oxigen/Nitrogen 
1           100       -0.1           100/-0.1
2           -9.9       9.9               -9.9/9.9
3           -199.8    199.6         -199.8/199.6
...
1200      81.0        4.5              81.0 /4.5
so the filter would filter on 
Oxigen/Nitrogen, like
-1000/-1000  ........1000/1000

Or Is there any other visual that could achive this?
Thank you

[Julia1234 · Accepted solution]

I suspect it may be better to use 2 clicers: Oxygen slicer and Nitrogen Slicer

[MasonMA]

@Julia1234  @FBergamaschi 

Hi, i was looking at this post too. My question is how did you manage to use 'value1/value2' in the slicer?

they are a list of text values and Power BI native slicer will limit them to Dropdown, tile or list. 

It looks like i can only use Ratio or Oxygen or Nitrogen values in slicer and have  'value1/value2' displayed in cards.. 

you can use Scatter Plot. 

[Julia1234]

Thank you!Yes, firstly, numeric_key has to be created, and then the "between" slicer can use this numeric_key, and show dynamic values in the card or textbox. 

Using ratio may not be accurate as 6/3, 10/5 will result in same 2.

Better use something like numeric_key = value1×ceiling(value2,100)+value2

Ironically, in my case, using value1/value2 was not too meaningful, so i created only value1 slicer.

[FBergamaschi]

I am sorry but your question and issue is unclear to me

Please show the expected outcome based on the sample data you provided 

Need help uploading data? click here

Want faster answers? click here

[Julia1234 · Accepted solution]

I suspect it may be better to use 2 clicers: Oxygen slicer and Nitrogen Slicer

[FBergamaschi · Accepted solution]

OK so it is a simple slicer thing, I sugget to use two separate slicers, one for each column and choose the style "between"

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI