Forum Discussion

sbrennan92's avatar
sbrennan92
Frequent Visitor
9 years ago

Tariff code range slicer

      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 ...
Show and Tell
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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? :smileyhappy:

 

Regards

sbrennan92's avatar
sbrennan92
Frequent Visitor
9 years ago

 

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

 

the 4 slicers together determine a 4 digit code.

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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. :smileyhappy:

     

    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