how can use measures for comperision in conditional formatting using power bi

[amal_01]

I made two measures to find the sales amount for this day and the previous day. Now, I want to make a comparison between the amounts. I want to use an up arrow icon and a down arrow icon to show me which value is higher than the other.

I mean like this 

I tried to use conditional formatting, but it is difficult to add a measure for comparison."

what sould i do ?

[KNP · Accepted solution]

Hi @amal_01,

I'm not sure what your measures are called but hopefully the below generic example will help.

Conditional measure...

__SalesIcon = 
    SWITCH(
        TRUE()
        , [Sales] > [Sales SPLY], "TriangleHigh"
        , "TriangleLow"
    )

You can see the icon names in this article.

https://radacad.com/power-bi-icon-names-for-conditional-formatting-using-dax

Apply this to the cell elements...

Here the field settings are applied using the measure...

I hope this helps.