Range slicer based on two dropdown slicers

[FUX]

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!

[Anonymous · Accepted solution]

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