Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
5 years ago
Solved

highlight cell value based on color

Hi    I have a table as visual in powerBI. i would like to apply some colors if a cell value in a certain column equals to something. for example if cell value = 2 then highglihgt the cell with re...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    abukapsoun 

     

    You have to create a measure and use that measure in the field format option.

     

    Example:

    DAX measure

    Color = 
var _cellvalue= SELECTEDVALUE('Table'[LastTransaction])
var _color= IF(_cellvalue="No","#198c19","#a500ff")
return _color

     

     

    Attaching the pbix file for your reference.

     

nandukrishnavs's avatar
nandukrishnavs
Community Champion
5 years ago

abukapsoun 

 

You have to create a measure and use that measure in the field format option.

 

Example:

DAX measure

Color = 
var _cellvalue= SELECTEDVALUE('Table'[LastTransaction])
var _color= IF(_cellvalue="No","#198c19","#a500ff")
return _color

 

 

Attaching the pbix file for your reference.

 

  • abukapsoun's avatar
    abukapsoun
    Post Patron
    5 years ago

    It worked like charm!! Thanks you very very very much. 

     

    And last thing, is it possible to have a button or a slicer dropdown (yes & no) in the report, if yes is selected, this conditional formatting will be applied, and if no, then nothing?

     

    Thanks again!

     

    • abukapsoun's avatar
      abukapsoun
      Post Patron
      5 years ago

      I was thinking if we can create a column with yes and no value. and then extend the IF formula, by saying if colum1 = no then color would be white. and if value = yes then we apply another if to evaluate which color to display. How can we do that with formula?

       

      • abukapsoun's avatar
        abukapsoun
        Post Patron
        5 years ago

        ive done it.

        thanks

         

  • SweetsMum's avatar
    SweetsMum
    Regular Visitor
    3 years ago

    Hi,

    Thanks for your solution.

    I am trying to use your solution but it is failed when I want to select the measure "color".

    I am using one dataset for my visual. Is it the reason?

    It is not allowed me to select it.