Forum Discussion

amal_01's avatar
amal_01
Helper I
1 year ago
Solved

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

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 ?
 
"DAX help" DAX
@Conditional Formatting
@PowerBI Report
  • KNP's avatar
    KNP
    1 year ago

    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.

     

     

1 Reply

  • KNP's avatar
    KNP
    Super User
    1 year ago

    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.