Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
THENNA_41
Post Partisan
Post Partisan

Up arrow and down arrow indication compare with different table Values.

I have two table  first table name called FInal and next table name called Template . both table table have Quantity column.

 

I am trying to compare both table value 

 

If FInal Quantity value is greater than Template Quantity .  it should be  UP arrow .

if Final Quantity values is less the then  Template Quantity , it should be Down arrow .

 

i have tired the below code for background color but its not working.

Color code = (
 
     MAX(FINAL[Quantity])  > MAX(template[Quantity]),"Green",
     MAX(FINAL[Quantity])  < MAX(template[Quantity]),"Red",
    "Black"
     )
 
looking for support . thanks in advance 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@THENNA_41 , You can create both arrow and color. Arrow using Unichar

 

/////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"
)

 

Use arrow a measure and color in conditional formatting using field value option

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

 

refer if needed

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/

View solution in original post

2 REPLIES 2
THENNA_41
Post Partisan
Post Partisan

@amitchandak  thank you sir its worked 

amitchandak
Super User
Super User

@THENNA_41 , You can create both arrow and color. Arrow using Unichar

 

/////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"
)

 

Use arrow a measure and color in conditional formatting using field value option

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

 

refer if needed

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors