Forum Discussion

gio1082's avatar
gio1082
Helper I
6 years ago
Solved

create slice

Hello,

 

I have this table and I would like to create a slicer for an average of LAR . So if  the average LAR is "greater than 96%" and "less than 96%"

Thank you. 

Need Help
Show and Tell
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi gio1082 ,

    Based on your desricption, I have defined the [Average of LAR] as a measure in my sample file like this:

    Average = AVERAGE('Table'[Average of LAR])

    Modified the previous measure:

    Measure = 
IF (
    NOT ( ISFILTERED ( 'Slicer table'[LAR slicer] ) ),
    1,
    IF (
        SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
        IF ( [Average] > 0.96, 1 ),
        IF (
            SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
            IF ( [Average] < 0.96, 1 )
        )
    )
)

    Refer the sample file: Create a slicer.pbix 

     

    Best Regards,
    Yingjie Li

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

     

4 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi gio1082 ,

    1. Create this table manually first:

    2. Create a measure like this, put it in the visual table and set its vallue as 1:

    Measure = 
IF (
    SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
    IF ( SELECTEDVALUE ( 'Table'[Average of LAR] ) > 0.96, 1 ),
    IF (
        SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
        IF ( SELECTEDVALUE ( 'Table'[Average of LAR] ) < 0.96, 1 )
    )
)

    Attached sample file that hopes to help you: create a slicer.pbix

     

    Best Regards,
    Yingjie Li

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

    • gio1082's avatar
      gio1082
      Helper I
      6 years ago

      Hi, 

       

      Sorry, for late response, this definitely what want but it not working for me. I think is because the average of LAR is metric. 

      So I have some products and a supplier who is responsible for that product. So Average LAR is a metric of the LAR to get the average for the supplier base on the products

       

      thanks 

       

      • v-yingjl's avatar
        v-yingjl
        Community Support
        6 years ago

        Hi gio1082 ,

        Based on your desricption, I have defined the [Average of LAR] as a measure in my sample file like this:

        Average = AVERAGE('Table'[Average of LAR])

        Modified the previous measure:

        Measure = 
IF (
    NOT ( ISFILTERED ( 'Slicer table'[LAR slicer] ) ),
    1,
    IF (
        SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
        IF ( [Average] > 0.96, 1 ),
        IF (
            SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
            IF ( [Average] < 0.96, 1 )
        )
    )
)

        Refer the sample file: Create a slicer.pbix 

         

        Best Regards,
        Yingjie Li

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