Colour formatting on Measure

[alielzaa]

Heya everyone!

Ive got another query, in my report I have a measure which states that if a text contains "true" it will display active and if its false it will display "closed".

Status = IF(MAX('table'[column]) = "True","Closed","Active")

I also wanted to add colour formatting to this in my quick measure. After some research I heard that colour formatting is not a option within DAX but I wanted to confirm

IF its not possible, Could I possible make a measure to display a green "active" if true else display a "red" closed by using two different text boxes?

Any help is appreciated.

[Anonymous · Accepted solution]

@alielzaa Please create a measure for color formatting

Color = IF(MAX('Table'[Status])="Closed","#ff0000","#66ff33")

Right click on status measure

Select conditional formatting >> Background color

Select format by field value

In based on field select Color measure created above

click oK 

[alielzaa]

Hey Vimal,

I cannot seem to find the conditional formatting option when I right click on status measure:

Kind regards,

Ali

[Anonymous]

Add that measure in to a table visual and right click on the measure name under visualizations. Please refer the scrrenshot for the same.

[alielzaa]

Hello @Anonymous 

I have it already on my vizualisation and added the field but i still do not get the colour formatting option.

Kind regards,

Ali

[Anonymous]

Right click on the measure name under fileds or you can find the option under format, next to fileld tab.

[Tahreem24]

Hi @alielzaa ,

You can create a masure like below with up and down arrow to show you status:

Icon = SWITCH([Status],"Closed",UNICHAR(129095),"Active",UNICHAR(129093))

Please give THUMBS UP for support and mark it as a solution if it helps you!