highlight daily changes power BI Matrix

[deeppawardk]

Hello,

 I have created a power BI matrix (which shows the status count) by connecting 5 excel files. I update & add the data in the excel files & refresh it on daily basis. 

I want to highlight the changes in the values from the previous day.

E.G. if for yesterday, the count of a particular value was 25, and today it has changed to 27, it should get highlighted 

[v-yetao1-msft]

Hi @deeppawardk 

Did you create a calculated column or a measure to show the values ? You can create a calculated column to return the values from previous day then compare these two values . If the refreshed value is greater than the previous value, return the refreshed value and configure conditional formatting for the refreshed value .

Since I don't know what your data structure looks like, there is no way for me to provide the formula directly. If possible, please provide your data and related formulas, it may help us to deal with your question easier .

Best Regard

Community Support Team _ Ailsa Tao

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

[amitchandak]

@deeppawardk , for that you need to have a snapshot of each day, and then you can compare. Unless you are talking about today and yesterday's value.

DAX append can help in that

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Then you DOD

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

then

Conditional formatting
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
https://www.youtube.com/watch?v=RqBb5eBf_I4