cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SPC_123
Frequent Visitor

Numeric range slicer and Measures

This document

https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range#limitations-and-consideration... 

notes that you cannot add a numeric range slicer for values in a measure.

 

Is there any alternative?

 

The example is a short list of all the countries to be listed and it would be helpful to sort based on the converted columns (measure).

Measure Filter.png

 

 

6 REPLIES 6
Super User IV
Super User IV

Re: Numeric range slicer and Measures

The information you have provided is not making the problem clear to me. Can you please explain with an example.





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Super User III
Super User III

Re: Numeric range slicer and Measures

Hi @SPC_123 ,

 

Theres is an alternative with disconnect tables.

 

Let's assume that you want to filter out all the information based on 3 ranges of values:

ID Range Min Max
1 0 - 10 0 10
2 11- 20 11 20
3 >20 20 999

 

Know you use the range column as your slicer and then make the following measure:

 

Slicer Measure = IF([Measure]>=MIN(Range_Slicer[Min]) && [Measure]<=MAX(Range_Slicer[Max]); 1 ;BLANK())

 

Then place this measure on the filters of the visualizaition and choose is not blank. that will filter out the visualization accordingly to your selection.

 

If you want to have the range slicer then create a table with values using:

Table 2 = GENERATESERIES(1;30;1)

 

And your measure should be:

Slicer Measure _limits = IF([Measure]>=MIN('Table 2'[Value]) && [Measure]<=MAX('Table 2'[Value]); 1 ;BLANK())

The use this measure to filter out the table again choose different from blanks.

 

Check PBIX file attach.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





SPC_123
Frequent Visitor

Re: Numeric range slicer and Measures

I have a list of countries and for each a numeric value in 'local' currency.  For example, the value for Breakfast in Australia is 25 (AUD). That value has been converted to USD using a Measure (Breakfast USD).

 

It would be helpful to provide a slicer to obtain certain results for that converted amount resulting from the Measure (e.g. only display countries where the Breakfast USD value is between 16 and 27).

Super User III
Super User III

Re: Numeric range slicer and Measures

Hi @SPC_123 ,

 

I have edit my post can you please check the last part of the post.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





Super User IV
Super User IV

Re: Numeric range slicer and Measures

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support
Community Support

Re: Numeric range slicer and Measures

Hi @SPC_123 , 

I am not sure how you define your measure, you could try to create each measure like below and set filter on measure to "is not blank". You could refer to my sample for details.

599.PNG


Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors