Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

One measure for Conditional Formatting applicable to multiple measure

I want to create a measure for conditional formatting that can be applicable to multiple measure.
Total_A and Total_B are measures

 

3 Replies

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion

    Hi Anonymous 

    You could do this with a calculation group.  Create a calculation item for the formatting you want to achieve and the conditions for it.  Instead of using a specific measure name use SELECTEDMEASURE() instead.

    Hope this helps!  ğŸ˜‰

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have tried that as well but issue is that how will I select calculation item in conditional formatting dialog box.
      I had created below calculated item having name "M":-

      IF(SELECTEDMEASURE()>25,"Red","Green")

       

  • GG23's avatar
    GG23
    New Member

    Have you found a solution for this? I'm needing the same. Thanks