topic Re: DAX - Range Slicer using Measure value in DAX Commands and Tips

DAX - Range Slicer using Measure value

aakif_aslam — Mon, 13 Mar 2023 13:03:09 GMT

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.

Re: DAX - Range Slicer using Measure value

tamerj1 — Tue, 21 Mar 2023 11:55:59 GMT

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

Re: DAX - Range Slicer using Measure value

aakif_aslam — Tue, 21 Mar 2023 11:10:30 GMT

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?

Re: DAX - Range Slicer using Measure value

tamerj1 — Tue, 21 Mar 2023 11:55:24 GMT

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

Re: DAX - Range Slicer using Measure value

rahulmathur — Tue, 21 Mar 2023 12:09:49 GMT

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