Forum Discussion
highlight daily changes power BI Matrix
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
2 Replies
- amitchandak
Super User
Anonymous , 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-data-to-it-using-incremental-refresh/
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-5c3243d1f9then
Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4 Hi Anonymous
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.
