Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional with icons

Good morning community: I have the following problem: Make a matrix table and you would need to add conditional icons to it. The problem is that each icon must indicate whether the amount in percent...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    You can try formula like the following:

    calculated column:

    Rank_semana = RANKX('Table','Table'[semana],,DESC,Dense)

    measure columns:

    following week =
CALCULATE (
    [Uso_cel],
    FILTER (
        ALL ( 'Table' ),
        'Table'[Rank_semana]
            = SELECTEDVALUE ( 'Table'[Rank_semana] ) - 1
            && 'Table'[prov_nombre] = SELECTEDVALUE ( 'Table'[prov_nombre] )
    )
)

    indicate =
IF (
    ISBLANK ( [following week] ),
    BLANK (),
    IF ( [Uso_cel] < [following week], UNICHAR ( 9650 ), UNICHAR ( 9660 ) )
)

     

    Hope this can work for you.

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

You can try formula like the following:

calculated column:

Rank_semana = RANKX('Table','Table'[semana],,DESC,Dense)

measure columns:

following week =
CALCULATE (
    [Uso_cel],
    FILTER (
        ALL ( 'Table' ),
        'Table'[Rank_semana]
            = SELECTEDVALUE ( 'Table'[Rank_semana] ) - 1
            && 'Table'[prov_nombre] = SELECTEDVALUE ( 'Table'[prov_nombre] )
    )
)

indicate =
IF (
    ISBLANK ( [following week] ),
    BLANK (),
    IF ( [Uso_cel] < [following week], UNICHAR ( 9650 ), UNICHAR ( 9660 ) )
)

 

Hope this can work for you.

 

Best Regards,
Community Support Team _ Eason