Tariff code range slicer

[sbrennan92]

Hello,

i'm trying to work a model for duties where certain nutritional values in a product can effect a tarriff calculation.

there a 4 different nutritional values that effect the tariff,

Milk fat, Milk Protein, Startch and Sucrose.

i want to create a model where i can put nutrition values on a slicer and changing it will give me the additional tariff code.

I've set up my data as above

I want the model to look like the below where i can slice the 4 nutritional values to give me one code but struggling to get the slicer where it can just give the code which belongs to the range.

[sbrennan92]

Hello,

maybe a little more clarity,

the combination of the four nutretional values should give only one code.

The above dataset so if product X had 0% for all 4 nutritional values the code is 7000,however if milk fat goes above 1.5% and all three other nutritional values stay below the lowest band that nutritional bucket the code is 7100.

so essentially i want 4 0-100 sliders (one for each nutritional value) where dax can read what numbers it is between and filter to give the one speicfic code.

The problem is from initial trials is using the greater then slider gives all nutitional values above that number not just the nutritonal bucket the slider value is currently in.

I believe the new what if parrameters can help but i'm struggling to get results

[v-ljerr-msft]

Hi @sbrennan92,

I want the model to look like the below where i can slice the 4 nutritional values to give me one code but struggling to get the slicer where it can just give the code which belongs to the range.

---

Based on my experience, it should give the codes which belongs to the range, if you have sliced the 4 nutritional values. What's the current result? Could you be more precisely with your real problem here? 

Regards

[sbrennan92]

Above is what i'm attempting to recreate in Power bi,

the 4 slicers together determine a 4 digit code.

[v-ljerr-msft]

Hi @sbrennan92,

Above is what i'm attempting to recreate in Power bi,

the 4 slicers together determine a 4 digit code.

---

I may understand your requirement now. You want each slicer to select a specific number/value instead of a range of numbers, right? 

If that is the case, I don't think there is an easy way to it in Power BI currently, as the current Numeric Range Slicer is intended to pick a range of numbers. Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. 

In addition, I also believe the new What If Parameter could work in this scenario. You can try create four What IF Parameters for each nutrition, then create relationships between the parameter and nutrition, then the What IF Parameters Slider Slicer should work as expected.

Regards