Forum Discussion

FUX's avatar
FUX
Regular Visitor
3 years ago
Solved

Range slicer based on two dropdown slicers

Dear all,

 

we are currently trying to build a dynamic range slicer that is the result of the division of 2 dropdown slicers (see picture below). As we are not very familiar with PBI and have only got this to work in Tableau, we kindly ask for your help.

 

The below picture is what we hoped for as an outcome. The range slicer shall than be used as a filter for other viz on the page (e.g., tables being filtered based on the slicer's setting, etc.). The two variables feeding the "numerator" and "denominator" dropdowns come from the same source table.

We highly appreciate your kind support!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi FUX ,

    Currently, there is no such layout for the numeric type Slicer. 

    If possible, you may consider splitting it into two drop-down slicers with filters to filter the visuals.

     

    Measure = 
VAR _rate = DIVIDE(MAX('Table2'[numerator]),MAX('Table2'[denominator]))
// Get the value of the numerator divided by the denominator.
VAR _filter = IF([RATE]>=_rate,1)
// Compare the above value with the value in the visual object and mark it as 1 if it matches the condition.
RETURN
_filter

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi FUX ,

    Currently, there is no such layout for the numeric type Slicer. 

    If possible, you may consider splitting it into two drop-down slicers with filters to filter the visuals.

     

    Measure = 
VAR _rate = DIVIDE(MAX('Table2'[numerator]),MAX('Table2'[denominator]))
// Get the value of the numerator divided by the denominator.
VAR _filter = IF([RATE]>=_rate,1)
// Compare the above value with the value in the visual object and mark it as 1 if it matches the condition.
RETURN
_filter

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum