Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost 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
Icon for Community Champion rankCommunity 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.

 

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.