Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Red & green Icon (traffic ) using Conditional formatting

Hello All,   I need help with a Conditional Formatting.   I have a measure in a Matrix named as Factor. It is derived using this DAX  Factor = ([Commited Amount] / (SUM(Tab1[OP])-SUM(Tab2[Sales...
  • Ritaf1983's avatar
    2 years ago

    Hi Anonymous   
    Since you did not attach sample data for the index you calculated, I prepared a simple data set like in the picture and will demonstrate a  solution with a simple sum formula.
    The table :

     

    parameters fo slicer:

    The measure (instead of yours):

    factor_ = sum('Table'[Factor])
    The measure for the conditional formatting of circles :
    flag_traffic = IF([factor_]>=Selections[Selections Value],"g","r")
    The modifying of conditional formatting :
     

     

     

    The result :

     

    pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly