Showing icon based on conditional formatting while comparing with the previous day data in a matrix

[subhendude]

Hi,

I want to visualize the sales data with an indicative icon. The data looks like below

I want to visualize the data in the following format in a matrix table

I am aware that the icons can be added using the conditional formatting. However I'm unable to set the rule such that it compares the data with the previous day and show the icon(red down, green up). Please note I will sort the column in descending order in the matrix table to bring 4th May in first olumn followed by 3rd, 2nd and 1st.

Any idea how can I visualize the data in this way?

Thanks 

[Anonymous · Accepted solution]

Hi @subhendude 

Thanks for the reply from @amitchandak , please allow me to provide another insight:

Create a calculated column as follow

Column = 
VAR _earlier = 'Table'[Date]
VAR _earliersales = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Items]), _earlier = [Date] + 1))
RETURN
[Sales] - _earliersales

Output:

Best Regards,
Yulia Xu

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

[subhendude]

Absolutely fantastic @Anonymous 

[amitchandak]

@subhendude , You can do this using measure with unichar icons, but those will measures and need use as another measure in table 

/////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 , to be used in conditional formatting using field value option
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

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/

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

[subhendude]

@amitchandak thanks for the pointers. I would prefer to use the _change in the condition formatting and render the icon based on the rules.

I am unable to figure out [Net Sales YTD] and [Net Sales LYTD] measures based on my data provided below. How do I calcuclate them?