cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
pxg08680
Resolver III
Resolver III

@Anonymous

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.

View solution in original post

2 REPLIES 2
pxg08680
Resolver III
Resolver III

@Anonymous

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.

View solution in original post

parry2k
Super User
Super User

check this link, I guess it will help.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors