topic Re: "Between" slicer with paired values: Oxygen/Nitrogen in DAX Commands and Tips

"Between" slicer with paired values: Oxygen/Nitrogen

Julia1234 — Tue, 08 Jul 2025 16:37:13 GMT

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

Re: "Between" slicer with paired values: Oxygen/Nitrogen

FBergamaschi — Tue, 08 Jul 2025 17:16:41 GMT

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

Re: "Between" slicer with paired values: Oxygen/Nitrogen

Julia1234 — Tue, 08 Jul 2025 17:25:56 GMT

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

Re: "Between" slicer with paired values: Oxygen/Nitrogen

FBergamaschi — Tue, 08 Jul 2025 17:27:38 GMT

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

Re: "Between" slicer with paired values: Oxygen/Nitrogen

MasonMA — Tue, 08 Jul 2025 20:36:13 GMT

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.

Re: "Between" slicer with paired values: Oxygen/Nitrogen

Julia1234 — Wed, 09 Jul 2025 00:38:07 GMT

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.