Show/Hide Up and Down Arrows based on if measure returns 1 or 0

[wonka1234]

hi,

I have a measure called "My Measure" and it returns 1 or 0.

ImageAVisibility = IF([My Measure] = 1, 1, 0)
ImageBVisibility = IF([My Measure] = 0, 1, 0)

if my measure returns 1, show the up arrows and hide the down arrow.

if my measure reutnrs 0, show the down arrow and hude the up arrow.

I have trouble implementing this with the arrows from insert->shapes.

How can I do this? I dont a web url or web image.

[Irwan · Accepted solution]

hello @wonka1234 

i am not sure to hide shape but you can do by making the color transparent.

- Measure equal to 0

- Measure equal to 1

if this can accomodate your need, then you can tweak your DAX a little bit.

Measure 2 = 
IF(
    [Measure]=1,
    "#FFFFFF00",
    "#FF0000"
)

Measure 3 =
IF(
    [Measure]=0,
    "#FFFFFF00",
    "#FF0000"
)

Measure 2 for Up Arrow and Measure 3 for Down Arrow.

True value is "#FFFFFF00" is a code for transparent color, and False value is "#FF0000" is a code for red color (you can change the False value to any color code you want).

in Shape option -> Style -> Fill -> Condition Formating (Fx) -> choose Field Value -> select the measure for Up or Down Arrow

do exact same method for border

Hope this will help.

Thank you.