cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyno
Frequent Visitor

Conditional Format: Icons for text Values

Hi! I have two doubts:

 

1) I have a colum with two TEXT values: Out Performed and Under Permformed. I would like to add a Red arrow for Under Performed, and a Green Arrow for Out Performed. How can I do that?

 

2) I have a table visual with two columns, both with percentage values. I would like to add a conditional coloured arrow to the first column in comparison to the other one. If percentage Column A y larger than percentage Column B, Green Arrow, otherwise, Red Arrow.

 

Thank you all!d

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @vickyno ,

 

It's suggested to create a measure used as a flag as shown below:

Measure = SWITCH(MAX('Table'[Text]),"Out Performed",1,"Under Permformed",2)
Measure 2 = IF(MAX('Table (2)'[Column A]) > MAX('Table (2)'[Column B]),1,2)

Then select Icons type under Conditional formatting option --> Format by Rules & Based on Measures -->Add rules like this:

conditiona formatting.jpg

Here is the final output :

output with arrows.PNG

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Eyelyn9
Community Support
Community Support

Hi @vickyno ,

 

It's suggested to create a measure used as a flag as shown below:

Measure = SWITCH(MAX('Table'[Text]),"Out Performed",1,"Under Permformed",2)
Measure 2 = IF(MAX('Table (2)'[Column A]) > MAX('Table (2)'[Column B]),1,2)

Then select Icons type under Conditional formatting option --> Format by Rules & Based on Measures -->Add rules like this:

conditiona formatting.jpg

Here is the final output :

output with arrows.PNG

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

amitchandak
Super User IV
Super User IV

@vickyno , On is that you can explore icon conditional formatting.

 

Second, you can create icon measure using unichar and icon color and then put them in new values and conditional  format using field value option

 

examples

 

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)


/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

 

 

Check more details at

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

 

More on measure color, conditional formating

 

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors