Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional formatting for Text Fields

Hi there,   I have a matrix which brings in Overall Status Assessment that is a text field that contains Red, Amber & Green. I would like to do conditional formatting which uses icons however it se...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Arul,

     

    Thanks, I got it to work. Just Power BI not playing nice, so instead of copying & pasting in the measure formula that you provided, I re-wrote it manually which then invokes the auto-populate feature for functions and it worked.

     

    Thanks

    Darren

     

  • lukiz84's avatar
    lukiz84
    3 years ago

    can you mark my measure as solution, thx

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Arul,

 

I think I still must be doing something wrong. 

 

1. When I bring in the Overall Status Assessment into a standalone table, all good as expected it returns the red, amber, green.

2. The numbers Measure formula is accepted as you provided, so all good there.

 

3. When I bring in the New Numbers Measure itself to appear as a table with just that field it errors and then when I try bring it in into the table together with the Overall Status, it errors.

 

4. And then finally, which is what I'm actually trying to do with the conditional formatting to set icons based on the value of 1, 2 or 3.

 

It errors. 

 

Any further help you can provide would be greatly appreciated,

 

Thanks

Darren

 

 

 

 

 

 

 

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

    Whats the error message in "See details"?