Forum Discussion

aakif_aslam's avatar
aakif_aslam
Helper I
3 years ago

DAX - Range Slicer using Measure value

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 

 

 

 

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      aakif_aslam
      Helper I
      3 years ago

      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's avatar
        tamerj1
        Community Champion
        3 years ago

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

  • rahulmathur's avatar
    rahulmathur
    New Member
    3 years ago
    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