Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Store my data and compare it automatically with old data before refreshing

I've linked my dashboard with excel sources and i designed the whole dashboard, but i'm just missing the main request that i received from my managament. 

 

We need this dashboard to compare or old data (before clicking refresh button) with or new data ( after clicking refresh button) to tells which area has new changes and what's the difference exactly? 

 

for example : i have a bar chart with 20 patents for march and when i refresh on april i had 18 patents only, i want to know exactly what happend in the last month's patents'. which department withdrew thier patent? 

 

i hope it's clear enough 😣😣😣😣

 

1 REPLY 1
lbendlin
Super User
Super User

Power BI has no memory, and no concept of global variables. You need to do that snapshotting in the upstream system.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors