cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ricardo Member
Member

Conditional format of a Value

Hi,

 

i'm using a Custom Visual - VitaraCharts Microchart - and i would like to know if it's possible to change the color in this and in other custom/MS visuals in a flexible way, via PBI options (quick metric?) or DAX:

 

Imagine that you have metrics realvalue, minvalueexpected e maxvalueexpected, all in the values area.

Is it possible to do a conditional format like this:

realvalue < minvalueexpected => realvalue appears in red

minvalueexpected < realvalue < maxvalueexpected => realvalue appears in green.

 

Regards

1 ACCEPTED SOLUTION

Accepted Solutions
pxg08680 Member
Member

Re: Conditional format of a Value

@Ricardo

You can use IF statement.

Column = IF(Table[RealValue] < Table[MinValue], 1, 0)

Drop this new column into visual and apply conditional formatting. If 1 red color , 0 green.

 

Hope this helps.

2 REPLIES 2
Super User
Super User

Re: Conditional format of a Value

check this link, I guess it will help.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






pxg08680 Member
Member

Re: Conditional format of a Value

@Ricardo

You can use IF statement.

Column = IF(Table[RealValue] < Table[MinValue], 1, 0)

Drop this new column into visual and apply conditional formatting. If 1 red color , 0 green.

 

Hope this helps.