How to highlight data difference after refreshing

[Anonymous]

Hi I would like to know how to highlight or extract the data diffrence after refreshing by Power BI desktop or service.

[amitchandak]

@Anonymous , That can only happen if you keep the snapshot of data

Check DAX append way 

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/

After that, you can use a measure/field value conditional formatting 

examples

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

[Anonymous]

Hi @amitchandak Thank you for your reply. Could I understand that there is no direct way / default features for Power BI to get the data difference?

[v-rzhou-msft]

Hi @Anonymous ,

You are correct. Currently, Power BI doesn't support to highlight the difference after refreshing. 

As far as I know, when you refresh your dataset, Power BI will load the new data and replace the old data. Then we couldn't find old data from dataset.

If we want to highlight the differernce, we need to compare the new data with old data. So only if you keep the old data and load a new column with the new data. Then we can create a visual and use conditional formatting to achieve your goal.

Color measure:

Color =
IF (
    SELECTEDVALUE ( 'TableName'[Old Data] )
        = SELECTEDVALUE ( 'TableName'[New Data] ),
    BLANK (),
    "Yellow"
)

Use Field value in format style.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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

[Anonymous]

Hi @v-rzhou-msft 

Thank you very much! That is very helpful.

Please kindly tell if the following senario can be  realized by Power BI.

There are differenet data sources.

Question 1. Can the data sources be connected automatically by setting anything of Power BI? 

Question 2. It seems that we still need to add color measure to highlight the new data, right? Is it possible to set the backgound color different for different data sources?

Question 3. Is it possible to schedule the refresh and combine to let them run automatically? Is there any limit for data source? For example, the file on onedrive will be refreshed based on the update timing, the refresh can not be scheduled.