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
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