How to calculate the trend beetween a date range in a Matrix

[Anonymous]

Hi! I´m trying to visualize the trend beetween a data if the previous is larger than the data the date before. I´m following the amount of online clients in an electrict grid acording to the type of client. My data updates every week. Looks a little like this

I want to be able to change the font color (or an arrow indicator) of each week of the online and offline clients if its larger than the previous day.

PS: Sorry for the image in excel, for privacy limitations I can´t show the actual POWER BI dashboard. But It looks almost exactly like the table.

[amitchandak]

@Anonymous , with help from a date table, you can create measure like

This Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('Table'[Qty]), previousday('Date'[Date]))

diff =[This Day] - [Last Day]

You can create color measure and use that in conditional formatting using field value option

color =
var _change =[diff]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4