Forum Discussion

prasa's avatar
prasa
Helper I
8 years ago
Solved

Dynamic formatting based on measure value

I want to have dynamic background color based on the measure value. If the measure value is greater than 90 show green and less than 90 show yellow like threshold. Font color change works too. 

I know we can do the conditional formatting for columns/fields but not able to apply it for a measure. How can we acheive this? 

 

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi prasa,



    I want to have dynamic background color based on the measure value. If the measure value is greater than 90 show green and less than 90 show yellow like threshold. Font color change works too. 

    I don't think there is an option to do it currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    Regards

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi prasa,



    I want to have dynamic background color based on the measure value. If the measure value is greater than 90 show green and less than 90 show yellow like threshold. Font color change works too. 

    I don't think there is an option to do it currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    Regards

    • prasa's avatar
      prasa
      Helper I
      8 years ago

      Okay thanks. I will add my vote.