Forum Discussion

gio1082's avatar
gio1082
Icon for Helper I rankHelper 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.

     

gio1082's avatar
gio1082
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.