DAX - Range Slicer using Measure value

[aakif_aslam]

Hello to all,

My client has requested to create a Power BI report based on the Excel format. There is a requirement for Slicers to filter the report by the range of percentage (0 - 20%, 20-40%).

I know for a slicer, it is better to create a calculated column and use it in a Slicer. 

Since I've created a measure to calculate dynamic Percentage, is it possible to create a slicer with a defined percentage range?

I need to check the feasibility of this, is it achievable or it's a limitation in Power BI?

Please help.

@amitchandak 

@Sahir_Maharaj 

@tamerj1 

@Greg_Deckler 

@FreemanZ 

[rahulmathur]

we can create slicer based on any column values

adding a new column or measure  which have this percentage range as value and create slicer on that column values

[tamerj1]

Hi @aakif_aslam 

create a table that contains the range name, lower limit and upper limit 

then use the following measure instead 

Dynamic Percentage 2 =
SUMX (
CROSSJOIN ( 'PercentageRange', VALUES ( 'Table'[Attribute] ) ),
VAR DynamicPercentage = [Dynamic Percentage]
RETURN
INT ( DynamicPercentage >= 'PercentageRange'[Lower Limit]
&& DynamicPercentage < 'PercentageRange'[Upper Limit] )
)

[aakif_aslam]

Hi @tamerj1,

Thankyou for the response.

From your response what I understand is the table name that is created with total of 3 columns. 

Below is the error I received -

Am I missing something here?

[tamerj1]

@aakif_aslam 
Please refer to my original reply. I have highlighted the key sentences in bold font.